Datatype Issue ..SSIS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » Datatype Issue ..SSIS

Datatype Issue ..SSIS

Rate Topic

Display Mode

Topic Options

Author

Message

iamsql1

Posted Tuesday, March 05, 2013 5:47 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 29, 2013 7:59 AM
Points: 24, Visits: 86

HI,
I have a task in ssis which loads data into DB from Source Files on my Drive, Issue is :
i have to convert DATA TYPE of one column having data type of VARCHAR() to DATETIME.

But when convert it into DT-DATE , it give me ERROR "OVERFLOW" but same conversion is done in sql server.
Why this conversion is not happening on SSIS LEVEL ?

Post #1426772

Daniel Bowlin

Posted Tuesday, March 05, 2013 10:04 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 11:53 AM
Points: 2,672, Visits: 2,416

Try DT_DBTIMESTAMP

Post #1426915

Paul Hernández

Posted Wednesday, March 06, 2013 7:36 AM

Valued Member

Group: General Forum Members
Last Login: 2 days ago @ 7:09 AM
Points: 73, Visits: 253

I think I faced this situation before and what I did (maybe is not the smart way) is to parse the strings using an expression in a Derived Column component. You will need a couple of tricks like the RIGHT function to force a leading zero for the month and days if they have only one digit, but at the end it is not so difficult.

Let me know if you have further questions.

Kind Regards.

Paul Hernández
http://hernandezpaul.wordpress.com/
https://twitter.com/paul_eng

Post #1427402

iamsql1

Posted Monday, March 11, 2013 10:28 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 29, 2013 7:59 AM
Points: 24, Visits: 86

Dear Rookie
ur advice did the trick.thanks

Post #1429386

« Prev Topic | Next Topic »

Permissions