Jack Corbett (1/19/2009)

---

If you are using SSIS then the lookup component is the current method to do this. If the databases are on the same server you could get...

i found the problem. some one broke my source table and so i had duplicates. after cleaning this table my stored procedure had no errors.

i have build my stored procedure but i get always this error:

Msg 2627, Level 14, State 1, Procedure import_DB_PARAM_HIST, Line 14

Violation of PRIMARY KEY constraint 'PK__DB_PARAM_HIST__29ADC38E'. Cannot insert duplicate key...

yes i would, but then i can't use a stored procedure because my transformation output can't be an input for the stored procedure, right?

if i say that i have to transform some data types you will killing me, right? 😉

How can i build such a query in ssis?

Thanks for your replay. i need a very hight performance solution because i have to handle a destination database with ca. 7tb. so my tables are very large.

Could i...