May 1, 2015 at 9:38 am
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
May 1, 2015 at 9:43 am
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.
May 1, 2015 at 9:49 am
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