Nov 9, 2007 #1 ton12 Programmer Joined Mar 9, 2005 Messages 58 Location 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 Joined May 24, 2006 Messages 77 Location 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