I am not using a query. I am using the dts wizard that came with SQL Server 2005 Express.
Thanks for your help.
Sorry bad wording on my part. Yes, you are using DTS but DTS is using query in the data pump to select the records from the destination and/or insert them into a table in your database.
What I meant by extending the query (bad wording... should have said extend the DTS) was to
Add an 'on success' workflow pipe onto the destination server and attatch it to an SQL task so that the SQL Task executes when the data pump transfer is successful.
In the SQL task you place the code that your trigger would execute
That was hard to explain, I hope I am making sense?
Also, just noticed you are using SQL Express. Not had any experience with express. Does it have that sort of control over DTS ?