question

jhop2002 avatar image
jhop2002 asked

How to convert dd-mon-yy to mm/dd/yyyy

I have a flat file source that is storing the date in dd-mon-yy format. When I try to convert to database type dbdate I get an error. Can anyone help me develop a solution using SSIS to convert this before I load into a table?
ssisconvertdatesdate-format
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.

1 Answer

·
Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
Configure your Flat File data source to use whatever regional setting is appropriate on the column and store it into a date-column in your database. Then you can retrieve the dates in whatever format you want (using for example SET dateformat).
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.

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.