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 Loop exit problem

Author  Topic 

PatDeV
Posting Yak Master

197 Posts

Posted - 2009-01-15 : 14:32:30
Hi all,

I have package that has for each loop. and i am passing files(excel) to provess and get data to database. all the process works fine. but when there is no excel file it fails. but i want to set it to exit out successfully when package finds no excel file in the folder.

how can i do that.

Please guide!!

thanks
pat

Nagaraj
Starting Member

14 Posts

Posted - 2009-01-16 : 01:55:29
Hi Dev,

Generally the package won't fail if there are no files in the directory.
Anyway let me know the error it is throwing..

Nagaraj.
Go to Top of Page
   

- Advertisement -