dynamic data flow task
Hi, Please try to use script task, in this script task you have to do it using code (Connection to your CSV file and the destination table) There is an important thing you must consider the number of columns so you must create your base column which can handle all different CSV columns or for each check if this table is capable of holding this data or not if yes insert it other wise create new table (Or column). GoodLuck I hope this is helpful. Elmozamil Elamir MyBlogPlease Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem Elmozamil Elamir Hamid http://elmozamil.blogspot.com
March 28th, 2012 9:33am

Hi, I have .csv files which needs to be populated into a staging table. The number of columns keep changing from file to file and all this has to be handled within SSIS data flow task without having to change the SSIS package. I am using SSIS 2008. Please guide me. Thanks in advance.............
Free Windows Admin Tool Kit Click here and download it now
April 1st, 2012 2:23am

Simple answer is no as data flow task does not work with dynamic meta data. You would need to create the package programatically else create multiple data flow task for each file (or one data flow with multiple source and destinations.)My Blog | Ask Me | SSIS Basics
April 1st, 2012 2:34am

Hi, Please try to use script task, in this script task you have to do it using code (Connection to your CSV file and the destination table) There is an important thing you must consider the number of columns so you must create your base column which can handle all different CSV columns or for each check if this table is capable of holding this data or not if yes insert it other wise create new table (Or column). GoodLuck I hope this is helpful. Elmozamil Elamir MyBlogPlease Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem Elmozamil Elamir Hamid http://elmozamil.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
April 1st, 2012 2:39am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics