Link to home
Start Free TrialLog in
Avatar of rwheeler23
rwheeler23Flag for United States of America

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.
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

>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?

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.
Avatar of rwheeler23

ASKER

Excellent, I WILL GIVE THIS A TRY.
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 TRIAL
Members 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.