I'm woundering if and how it is possible to add a entity to a report model that is directly associated with a database table after the model has already been created?
Thanks for the help if there is any.
You will need to refresh the Data Source View (.dsv) first to pull in the schema for your new table. You can then right-click on the root node in the Model Designer and choose New->Entity. Set the Binding property of the new entity to the new table.
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
