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 |
|
Trudye
Posting Yak Master
169 Posts |
 Posted - 2009-08-08 : 13:14:52
|
| Hi everyone, I have several files with different filenames that I need to read in thru a For each Loop. I have tried several ways to setup the Filename for the connection. For instance one filename is ATA.New.Empl, the files are being sent without an extension. All the filenames start with ATA but the rest of the filename is different I have tried ATA*^; ATA*.. What can I use in the connection to pull in all of the files in the folder.Thanx,Trudye |
|
|
Trudye
Posting Yak Master
169 Posts |
Posted - 2009-08-08 : 16:31:15
|
| i figured out why the wildcard wasn't working. I needed to add the wildcard after I selected a valid filename from my chosen path. Now I have a new problem. I am getting the following msg:The processing of file "" has started.Warning: 0x80070003 at Header, Flat File Source [1]: The system cannot find the path specified.I have tried using the relative path (z:\folder1\folder2\folder3\filename.ext AND\\severname\folder1\folder2\folder3\filename.ext Any help is appreciated |
 |
|
|
|
|
|
For each Loop w/ Wildcard