Post reply

SSIS Package - For Loop and File System Task.

  • November 12, 2008 at 6:28 am

    #125892

    We are having a problem when we try to use a Foor Loop when reading files from a folder. This works fine when we use a ForEach loop but the problem seems to be a compatability problem with the For Loop and the File System Task. We really need to be reading the files in batches as we can’t process all of the files in one go.

    Any ideas?

  • November 12, 2008 at 7:10 am

    #897493

    What issues are you getting ?

  • November 12, 2008 at 7:14 am

    #897496

    We are getting the following error Empty file name is not legal. Parameter name: SourceFileName.

  • November 12, 2008 at 11:15 pm

    #897902

    Okay, i will need more information to help you. Are you sure you are passing the file name in your file system task. It will not work if you pass just the folder path.

  • November 13, 2008 at 1:56 am

    #897927

    We are not passing the file name, we are expecting it to pick it up from the folder. I take it from your explanation this is not the case. We are now using script to loop through the files in the folder and move them to the new folder for processing. Thanks.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply