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