Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Datatype Issue ..SSIS Expand / Collapse
Author
Message
Posted Tuesday, March 5, 2013 5:47 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, September 16, 2013 11:20 AM
Points: 45, Visits: 139
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
Posted Tuesday, March 5, 2013 10:04 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 24, 2014 8:41 AM
Points: 2,818, Visits: 2,553
Try DT_DBTIMESTAMP
Post #1426915
Posted Wednesday, March 6, 2013 7:36 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 21, 2014 3:46 AM
Points: 115, Visits: 472
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
Posted Monday, March 11, 2013 10:28 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, September 16, 2013 11:20 AM
Points: 45, Visits: 139
Dear Rookie
ur advice did the trick.thanks
Post #1429386
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse