In SQL Server 2012 Imports (using SQL Server Import And Export Wizard) from web server where a datatype - "datetime" but in local sql 2012 server change datatype to "smalldatetime"

Question

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

sunder.bugatha Ten Centuries Points: 1227 More actions · Answer 1

save it as a SSIS package and use data conversion transformation to convert it to relevant datatype.

Phil Parkin SSC Guru Points: 247180 More actions · Answer 2

sunder.bugatha (12/11/2014)
save it as a SSIS package and use data conversion transformation to convert it to relevant datatype.

Any data that has already been lost during the conversion to SmallDateTime will not magically reappear if converted back to DateTime.

Better to change the datatype of the source columns.