dbTalk Databases Forums  

SSIS - how to fail the package when the for each loop container finds no files

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss SSIS - how to fail the package when the for each loop container finds no files in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
KR
 
Posts: n/a

Default SSIS - how to fail the package when the for each loop container finds no files - 09-06-2007 , 01:30 PM






Hi,

I have created a For Each Loop Containers to loop through the files in
the directory and process them. If it does not find any files in the
directory it should fail the package. However it does not do so by
default. It reports success. How do I change this behavior. I would
like it to fail the package if it does not find any files.

Help is greatly appreciated
KR


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.