How do I have a package skip a container when a file is missing?

  • Here is my predicament, I have 8 files coming in from a client to be processed. Sometimes, the client does not place those files in the ftp folder. How do I make the containers that are dependent on those files not run (but run the rest of the package) when a file is missing?

    The files are added by the client to an SFTP folder that are automatically moved to a folder that SSIS has access to. The goal was to make this a completely automated process. The files that the client loads are moved to an archive folder and renamed with a timestamp.

    Thanks in advance,

    Frank

    SSIS 2012, SQL Server 2012

  • I usually like to create empty file templates of those files, and replace them with the files I receive from the source. That way you could still execute all your data flows.

  • The files are added by the client to an SFTP folder that are automatically moved to a folder that SSIS has access to. The goal was to make this a completely automated process. The files that the client loads are moved to an archive folder and renamed with a timestamp.

Viewing 3 posts - 1 through 2 (of 2 total)

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