question

aRookieBIdev avatar image
aRookieBIdev asked

DateTime to Small Datetime

Hi , I have one of the columns as Datetime field which i need to type cast to small date time in SSIS . I can not change this in source query since its from a flat file. Please provide any possible suggestions. Thnaks, Kannan
ssisdatetimecast-convert
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Usman Butt avatar image
Usman Butt answered
You did not specify the destination? If that is a table, then by handling the out of range values (Redirect those rows) and nulls (either by retaining nulls OR some other way), there should not be any problem. you could specify DT_DBTIMESTAMP for the source column.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.