When deploying a uniqueidentifier column that contains NULL values, I get an Invalid Cast exception. After filling up all values it works fine.
The answer to this is already out here on the forum as I have answered this a number of times already...you cannot have NULL data in a deployment data package. We may make a change in the future to allow this...but it will require a relatively large change in the way teh data is packaged...and then making it backward compatible, etc.
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.
Read the first answer.
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.
First time I have ever heard of someone trying to deploy a timestamp value since this is generated by the SQL side...I can add this to the list to look at so ensure that a timestamp column never tries to deploy data. I will put this on the list, but we are in the middle of making a lot of changes to the DDT anyway, so this will not be an immediate change.
I can provide you with the package if you think it could help more.
Not necessary....the top 2 problems will not be changed (at least in the immediate future). I will look at the time stamp deployment next week.