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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 ssis tutorial

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?
Go to Top of Page

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...
Go to Top of Page
   

- Advertisement -