Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to ignore empty files within a ForEach Loop Container

Status
Not open for further replies.

ton12

Programmer
Mar 9, 2005
58
GB
I have Data Flow task to move Flat Files to a Table.
Some of the files to be moved might be empty.

I'm using a ForEach Loop container. I just want to ignore
empty files or Files with size 0.

Any suggestions.

Ton
 
When you say 'move' I assume you mean import? and therefore why does it matter if the files are empty. Unlike dts, SSIS will just import nothing.

If there is another reason you could use a script task (System.IO.File) to check the file size.

A
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top