January 21, 2010 at 5:55 am
Hi,
I'm designing a SSIS package to loop through existing csv files within a network folder and to import each one into a single SQL table using a ForEach container.
I've looked at the following link which appears to be a frequently referenced design template on the internet:
http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx
but I can't quite understand how to 'Import the files' using the data flow task in the example.
The csv files reside in the network folder: \\ServerName\Data\csvFiles and the SQL table is Server001.Labdb.dbo.PrepareTable
After they have been imported, i need to move them to \\ServerName\Data\csvFiles\Archive.
Any ideas please?
Thanks in advance,
January 21, 2010 at 8:35 am
I'm not sure what your question is as the link you provided does a pretty good job stepping you through the process.
Can you share what you have and then we can help you extend or fix what you have done?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 21, 2010 at 9:44 am
Within the loop you can use a file system task to move the file based on the source you have in a variable. I wrote an article a few months ago that touches on moving the file after it's been processed.
January 22, 2010 at 6:13 am
Hi J.D.
That is spot-on! Althought the original link I posted was a huge help, your additional posting was exactly what I needed.
Many, Many Thanks,
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply