x

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
more ▼

asked Dec 21, 2011 at 05:14 AM in Default

aRookieBIdev gravatar image

aRookieBIdev
2.3k 47 55 61

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
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.
more ▼

answered Dec 21, 2011 at 05:52 AM

Usman Butt gravatar image

Usman Butt
13.9k 6 8 14

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x927
x94
x29

asked: Dec 21, 2011 at 05:14 AM

Seen: 1170 times

Last Updated: Dec 21, 2011 at 06:01 AM