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 characters needed characters left characters exceeded

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

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

· Write an Answer
IT1 avatar image
IT1 answered
1 comment
10 |1200 characters needed characters left characters exceeded

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

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.