|
sccrsurfer
Starting Member
USA
43 Posts |
 Posted - 01/31/2013 : 12:51:23
|
Hi guys,
I've been trying to set up a package in SSIS to import all *.txt files in a folder. Here is what I've done:
ForEach Loop container with data flow task within
In the ForEach, I want the package to loop through all files and look for wildcard .txt files and offset columns based on a "|" delimiter. Have severe trouble getting everything to work. Can I get help specifically in the Expressions portion of the Foreach loop editor? I want to have a "connection string" property but it never populates.
Please explain how you would set this up step by step or if I'm doing anything wrong.
Thanks! |
|
Import *.txt from a folder into SQL 2005 via SSIS
