question

pvsrinivasrao avatar image
pvsrinivasrao asked

How to convert string to DateTime in SSIS

Hi Source is string - 20091101 (yyymmDD) format.( coming from text file) Destination is Table column- DateTime (data type). (table) i am looking for a transformation which gives me puses string as datetime with (yyyy-mm-dd) format. output should be 2009-11-01. Any inputs.
sql-server-2008sqlssistransformation
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

Usman Butt avatar image Usman Butt commented ·
The solution is very simple but can you please let us know why you need to change the ISO format to language dependent format and when the destination column is already of DATETIME datatype?
0 Likes 0 ·

1 Answer

·
IT1 avatar image
IT1 answered
Hi , http://bi-polar23.blogspot.com/2007/05/having-trouble-getting-date.html Hope this helps...
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

IT1 avatar image IT1 commented ·
let me know if it works...
0 Likes 0 ·

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.