SSIS to Check for File Help!

[octavian10]

Hello everyone,
I have project that loads data from a flat file into an sql table and performs mutipule tasks with this imported data. This project works great, but now I have to check for the exixtance of an other file before any other part of this project executes. This other file is a text file with no data it, it is just being used as a trigger, if it is there run the next part of the project (load data from flat file) if not do nothing. While I am ok with .net I have no idea how to make this happen. Reaserch this far says to use a Script File to accomplish this but I do not even know where to begin. I am not sure how to set up the Variables or the Precedence for this script either. If someone could help me with this I would very much appreciate it.

"I hear and I forget. I see and I remember. I do and I understand."
- Confucius (551 BC - 479)

 

[mrdenny]

I would recommend that you use a T/SQL script in a job step before the SSIS package. You can use the xp_fileexists procedure to see if the file is there.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog