Are the two columns the same datatype i.e
CREATE TABLE DTCompare (smallDT smalldatetime, LargeDT datetime)
INSERT DTCompare VALUES(Getdate(),Getdate())
select * from DTCompare
This shows that the smalldatetime will drop the milliseconds.
I have just tried a DATETIME column copy to a DATETIME field and it took the
Allan Mitchell (Microsoft SQL Server MVP)
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
: I have the same problem.
: I used a SQL command to dynamically create the
: DTSDestination("column") = DTSSource("column")
: lines. Then I executed the whole thing, but the
: microseconds were dropped.
: I tried to specify the column-assignment directly without
: using the transformation script and i worked.
: Isn't there a way to get the script copy microseconds as well?
??>> While inserting records from SQL2K to SQL2K using the DDQ task, the
??>> milliseconds are not carrying over for datetime fields. For example,
??>> '2002-10-24 03:04:37.010' is being transferred as '2002-10-24
??>> How can I get thedatetime field to be inserted as-is?
--- Microsoft Outlook Express 6.00.2800.1106