Hi,

I have added a new Data Deployment package in my DDT project and I get a few exceptions:

1. When deploying a uniqueidentifier column that contains NULL values, I get an Invalid Cast exception. After filling up all values it works fine.

2. When deploying a nvarchar column that contains NULL values, I get an exception saying that it cannot convert DBNull to String. After filling the values here too, it works fine.

3. When deploying a timestamp column, I get an SQL exception saying that timestamp columns cannot be assigned. Which is true, since timestamps get values on their own.

I can provide you with the package if you think it could help more.

Sorry - I really was being thick.







I read http://forum.strataframe.net/FindPost10529.aspx - Ben's reply over a year ago saying you had to set the combobox at the bottom of the Table Properties to the field used for rowversioning and I looked at that combo and set it to the pk ....



Slowly it is starting to gel ... slowly



SET OPTIMISTIC TIMESTAMP

SET THE ROWVERSION COMBO TO THE TIMESTAMP FIELD

Hi Charles!

Hope everything is fine with you.

You might consider using row version instead...

http://forum.strataframe.net/FindPost16196.aspx