26 From one CSV, Import few columns to one destination and few to another in SSIS

From one CSV, Import few columns to one destination and few to another in SSIS
Download the file\script used in the Video from below link

From one CSV, Import few columns to one destination and few to another in SSIS
read csv file using script task ssis
how to import flat files with a varying number of columns
ssis read text file line by line
ssis import multiple csv files into multiple tables

[nivetha.meceskct]

I was expecting this video thanks a lot Aqil

[pareshyadnik]

Thanks very much Aqil... 👍👍👍.. really well explained

[sri]

Hi. How to handle.. if we have got new column in the CSV file but we dont want to load that column in to the Table. currently our package getting failed when ever new column added to the CSV file. We would like to skip all those new columns and proceed with the existing columns which are mapped with destination DB columns. . COuld you pls hele me on this.

[reddyabhik]

Very well explained. But in the same scenario if the move names are repeated by different person names. And we want to load only distinct movie names in Movie Table. Can we achieve?

[shobhitbisen]

Hello Aqil, thanks for all the videos, recently i am facing one problem like i have to transfer a file in archive and i want to transfer 5mb data in one file and remainin into next file like that.. and file created in archive must be in number like dgfdgsgd_1, dfghfdh_2, dghdf_3. please give some solution. thank you so much for your teaching.