Nov 9, 2007 #1 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
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
Nov 30, 2007 #2 Alan0568 Technical User May 24, 2006 77 GB 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 Upvote 0 Downvote
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