divyanth (3/25/2010)

---

Use Import/Export wizard in SSIS to complete the Data Flow Task part. You will be left with Control Flow task and all you need to do is use a For Each Loop and place the data flow task in the FEL and provide your Directory path and File Type which would be *.csv if you want to import all files in that dir or use a different pattern if necessary... Alo, you need to change few other things as in the link below. That will give you a good start

http://consultingblogs.emc.com/jamiethomson/archive/2005/05/30/SSIS_3A00_-Enumerating-files-in-a-Foreach-loop.aspx%5B/quote%5D

Thanks for the rpely but once again I am reminded why I hate SSIS so much. Thank God not everything in the technical world works like SSIS. If writing a SQL Query followed the SSIS process then in order to write a T-SQL Query that would return the text "Hello World" I would have to

1) Define a complete ASCII character set whether I need to use all the characters or not and NO you can't use some default or template set.

2) Provide the DDL to create a base DB with at least 1 user Table even though you aren't storing any data.

3) Set up 2 dozen pointers and aloocate space for both 32 bit & 64 bit data types (how is this even related to T-SQL??)

4) Finally, I'd have to put together a SQL proposal and prey that the query optimizer doesn't find any grammar mistakes or I go back to base0 and do not collect anything along the way.

Man I hate SSIS. Why can't the darn thing be just a little logical? I bet if we put 2 identical twins in different rooms I could teach mine the basics of quantum mechanincs before a SSIS guru can teach teh other to do the SSIS equivelant of the 'Hello Wordl' program sample. This assumes there is an actual SSIS guru verses people who have just sweated out enough years on SSIS that they know what not to do.

Seriosuly, now that I've ranted... I looked at the example you referenced and downloaded the sample file the author provided but its still not clear. What I rally need is an on line sample/example walk-thru that takes you step by step thru every click and setting you gott ado, assuming absolutely nothing, on how to add a ForEachLoop to an existing flat file import where the destination is a Dtabase table.

Know of anything like that?

Thanks