Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
sccrsurfer
Starting Member
43 Posts |
Posted - 2013-01-31 : 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 withinIn 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! |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|