CODEWITHSUNDEEP
ssissql-server-2012script-componentderived-column
BRDroid
BRDroid

Reputation: 4388

Change date format of data coming from flat file SSIS

I am reading data from a flat file and storing them in a OLE DB destination. In the flat file, dates and in various formats
17/02/2014,
28-Apr-14,
30.06.14

I have used a Derived column transformation to check for empty columns and replace it with null. As far as I have seen SSIS and data base accepts 17/02/2014 format and 28-Apr-14, 30.06.14 are rejected.

I want to convert 28-Apr-14 and 30.06.14 to a valid format which DB accepts.

I have researched a bit and read that Script task can do it but I am not sure of the code how to check this.

Could you please guide which is the best way to do this.

Any suggestions/help is much appreciated.

Thanks Rao

Upvotes: 1

Views: 696

Answers (1)

Joe C
Joe C

Reputation: 3993

Check out my answer on the following question. This should work for you as well.

SSIS clean up date from csv file

Upvotes: 1

Related Questions