Error converting DateTime field to DateTime2 in SQL2008 with DDT

Author	Message
Edhy Rijo	E Edhy Rijo posted 15 Years Ago Topic Details Share Topic
E Group: StrataFrame Users Posts: 2.4K, Visits: 23K	Hi Trent, Today I upgraded my dev computer to SQL2008, I want to take advantage of the new DateTime2 and Date fields in SQL2008, after changing one of table in the DDT to use DateTime2 and deploying the package I got the following error: X 4/13/2009 1:50:05 PM -> Altering table 'Inventory' failed. X 4/13/2009 1:50:05 PM -> FailedOperationException X 4/13/2009 1:50:05 PM -> Alter failed for Table 'dbo.Inventory'. X 4/13/2009 1:50:05 PM -> ExecutionFailureException X 4/13/2009 1:50:05 PM -> An exception occurred while executing a Transact-SQL statement or batch. X 4/13/2009 1:50:05 PM -> SqlException X 4/13/2009 1:50:05 PM -> Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query. X 4/13/2009 1:50:05 PM -> X 4/13/2009 1:50:05 PM -> Source : Microsoft.SqlServer.Smo Shouldn't the DDT take care of running whatever command is required to do this type of conversions? or this must be handle via the Pre/Post script? Edhy Rijo Attachments CardTrackingSystemDDT_results14.txt (179 views, 5.00 KB)
	Reply Like 1

Merge into selected topic...

Merge into merge target...

Merge into a specific topic ID...

Edhy Rijo - 15 Years Ago

No...this is an entirely different data type. So the DDT (at present)...

Trent L. Taylor - 15 Years Ago

Thanks Trent, I will play with the scripts to handle this.

Edhy Rijo - 15 Years Ago

Login
Remember Me Reset Password Resend Validation Email Login