If File Exists, run package?

[Glowworm27]

I may be overthinking this one, so I am asking for some guru's to lend me some insight.

I am working on a SSIS package, and it will be scheduled to run daily. Problem is somedays it may not need to be run.

If a file exists on a certain folder, then we need to grab that file and process it. IF the file does not exist the package needs to exit gracelfully, and not crash out.

I was thinking about using the File System task but it doesnt do File Exist only copy, delete and move functions

I was also think to use a Script task and pass execution to one branch if the file exists, or send the execution to the end of the package and let it complete successfully

Any help please?

Thanks in advance


George Oakes
CEO & President
COPS Software, Inc.

http://www.cops2005.com

Programmer & Developer
.Net, WSS 3.0, SQL DBA
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net

 

[Glowworm27]

I answered my own question by doing more googling.

Here is how this developer solved my problem, and his

http://dichotic.wordpress.com/2006/11/01/ssis-test-for-data-files-existence/

Peace


George Oakes
CEO & President
COPS Software, Inc.

http://www.cops2005.com

Programmer & Developer
.Net, WSS 3.0, SQL DBA
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net