dynamically with just 1 dataflowtask
SSIS isn't that dynamically, you have to fix define the data source for each CSV file with matching data types, same for the data destinations.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi,
I have 5 different files with different columns and I would like to load them into SQL tables via SSIS.
I have the option of writing 5 dataflow tasks. however is it possible to load them dynamically with just 1 dataflowtask
dynamically with just 1 dataflowtask
SSIS isn't that dynamically, you have to fix define the data source for each CSV file with matching data types, same for the data destinations.
Hi AshishNZ,
We can use just one Data Flow Task , and then drag 5 Flat File sources and 5 OLEDB destinations.
One source or one destination can only read one type of structured metadata.
Please refer to the following links and pictures:
Populate external metadata columns
Best Regards,
Mona
----------
If the response is helpful, please click "Accept Answer" and upvote it.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more