Hi,
I am mapping an entity from SQL 2005 to another entity in another system on SQL 2000. Since the destination system has its own ID generator, I want to keep the generated ID for each row of my table in a column of my table in SQL 2005. The new column is in the dataset now , but I don't know how to update my table to have that column values (The OleDbDestination just insert new items.)
Samy
OLE DB Command transform is used to do updates.
You may want to read the last paragraph on this blog post: http://www.sqljunkies.com/WebLog/ashvinis/archive/2005/02/03/7275.aspx
-Jamie
No comments:
Post a Comment