|
mahi84
Starting Member
India
1 Posts |
 Posted - 06/30/2011 : 03:31:24
|
Hi all ,
Recently i am starts to works with Sqlserver Intergration service SSIS ..
i have a requirement to do the bulk upload of CSV file ito the sql server 2008 . for that i had used .SSIS . Flat file source and OLEDB Destination . in addition to the columns in the csv , i am inserting the user ID , date of upload using the derived columns . its work good
The requirement got changed so what , now the csv file is having the dynamic columns for example . i have developed and mapped it for 56 columns . if the user is importig the csv file with 40 columns . the upload is not done properly .please suggests some ideas ..
--------------
Thanks&Regards
Mahendran |
|
SSIS Dynamic column mapping
