Hi all

I'm looking for some help in SSIS on SQL Server. I have the basics I think. Here is my senerio

We are using the SSIS package to upgrade a customer database. The inital process is straight foreward. We are migrating (transfroming old table into new data database tables). The inital run of the package this is stright foreward, I created a DataFlow task. The task consists of an OLEDB datasource set to SQL Command and a SQL statement I wrote ( a select statement) is run. The output of this is sent to the OLEDB destination (writes the results of the select statement to the new table). This works fine.

Now the problem. If the process is stoped and restarted I don't want this process to run again for the tables that have been completed. How do I get the SSIS package to tell that the source table has been deleted and is now longer required to be processed. I can't in a Data task do a select from the Information Schema tables to see if the source has been removed since I can't then create a new another OLEDB Source container to move the data if the table is still present.

Gary