DTS Problem : Insertion of failed records
-
Hi, :) I need to know how to insert all the records to a table which are fail to be inserted when executes a DTS package. The table is different with the destination or source table. I realize there are many scenarios. One of them is using the text file - as the source in DTS package - that is generated when exception occured in execution process. But i think that this is a complicated and not the best way. I also need to insert the current date to the table along with the failed records. So, please help to solve this problem :confused: Thanks.
-
Hi, :) I need to know how to insert all the records to a table which are fail to be inserted when executes a DTS package. The table is different with the destination or source table. I realize there are many scenarios. One of them is using the text file - as the source in DTS package - that is generated when exception occured in execution process. But i think that this is a complicated and not the best way. I also need to insert the current date to the table along with the failed records. So, please help to solve this problem :confused: Thanks.
Could you try :
INSERT INTO table1 VALUES (SELECT * FROM table2)or something similar Perhaps evenCREATE TABLE table2 AS (SELECT * FROM table1)Can't remember exact syntax though (as you might have guessed) "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox