Hi All,
Can this be done and if so can you give a bullet list of the steps need to accomplish this.
I need to load a bunch of files into a stagging table. Need to loop through the files and load them.
Thanks,
Michael
Essentially you're looking at is the following:
1) A for each container using the for each file enumerator.
2) Within that, you'll need to assign the filepath to a variable
3) Within the container, create a dataflow task with a flatfile source and a sql server destination, mapping the columns.
4) dynamically change the connection string of the flatfile source (properties/expression)
Hope this helps
|||Thanks Rick,
That is a good start, I will see how far I can get.
Michael
