Hi, here is a sugestion:

Create a View like this:

CREATE VIEW VWAuxTable

AS

SELECT ROW_NUMBER() OVER (ORDER BY c1) PK, c2 FROM

(

SELECT c1, c2 FROM TABLE1

UNION ALL

SELECT c1, c2 FROM TABLE2

) T

Where TABLE1...

Hello Thomas,

After some investigation on the subject you mencioned I came to a conclusion about this.

I tried Error Handling with Execute SQL Tasks, Bulk Insert Tasks, Data Flow Tasks, Execute...