October 22, 2007 at 2:40 pm
Hey,
I need to import multiple .csv files from a folder into one table on an ongoing basis
I will not know the number of files each time running this process.
What task and/or approach should I use?
Any suggestions are greatly appreciated.
October 23, 2007 at 3:34 am
Use a For Each Loop container using a variable. Use this variable in the flat file connection.
See tutorial in BOL: Creating a Simple ETL Package---Lesson 2: Adding looping
October 23, 2007 at 7:21 am
See tutorial in BOL: Creating a Simple ETL Package---Lesson 2: Adding looping
Where do I find this tutorial? And what is BOL?
I have googled this and searched on this site, but it gives me nothing...;-(
October 23, 2007 at 7:32 am
BOL stands for Books OnLine. Don't touch MS SQL without it!!;)
http://msdn2.microsoft.com/en-us/library/ms130214.aspx
Or download it:
The tutorials are in BOL.
October 23, 2007 at 7:38 am
Oohhh, sorry for being such as spazz.
Thanks for clearing that up.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply