rwheeler23
asked on
Run SSIS project only when new spreadsheet is detected.
I have a series of SSIS projects that run automatically each morning. Part of what they do is attempt to standardize addresses and retrieve latitude and longitude values from a master table. This master tables does get updated every few months. My question is this. Is it possible within SSIS to detect if a file exists in a folder and if it does proceed with the import and when the import is done to delete this file? I don't want the project to run on the same data morning after morning but only when an updated file is dropped into this folder. This input file is an Excel spreadsheet and the destination is a SQL table.
ASKER
Excellent, I WILL GIVE THIS A TRY.
ASKER
Can you point me to an example of how to set this up? I have added a File System Task and pointed it to the file but I do not see how you assign a variable to be true/false based on file existence.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Yes. Should be able to add a File System Object (FSO) Task to detect if the folder/file exists, assign the result to a variable, and then use precedence constraints (aka green arrows) after that object where N ends the package, and Y continues with other tasks.