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 |
cognos79
Posting Yak Master
241 Posts |
Posted - 2008-08-08 : 23:47:14
|
I am trying to follow the ssis tutorials in sql server help file. "Adding Looping". which loops through all text files in a folder and uploads them to sql server. I followed the steps still i get the following error: "[Extract Sample Currency Data [1]] Warning: The system cannot find the path specified. "the file path i specified in foreachloop container is correct and there are files in it.Any ideas??? |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-09 : 00:13:45
|
Does sql service account have permission to access them? |
 |
|
cognos79
Posting Yak Master
241 Posts |
Posted - 2008-08-09 : 00:34:39
|
got it working...I have to drag the data flow task into foreachloop container... |
 |
|
|
|
|