Post reply

Scripting a column Str to format to Date time

  • August 13, 2008 at 10:58 am

    #196969

    I'm a little new to SSIS/DTS and have a problem that I'm not sure how to approach.

    Im pulling in data from a text file, using a data conversion to convert to unicode, and writing data to the DB.

    All the fields are porting over nicely except for the 2 columns that I'm trying to force into a date format so it will actually go into the DB. Ive tried every form of DT_InsertEverydataTypeInvolvingDateHere. Someone suggested scripting it.

    Now the issue is I have NO idea how to pass the data im converting to a script and back to the data convert, or if thats even how its done. Once I can pass it I can code it np just passing the string or column would really do the trick.

    plz help?

  • August 14, 2008 at 7:09 am

    #858021

    If this doesn't help, can you post a little more detail? Jack Corbetts sig gives a link to a good guide to the type of info that's helpful

    http://sqlblogcasts.com/blogs/jorg/default.aspx

    hth

    Andrew

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • August 14, 2008 at 9:49 am

    #858194

    andrew gothard (8/14/2008)

    If this doesn't help, can you post a little more detail? Jack Corbetts sig gives a link to a good guide to the type of info that's helpful

    http://sqlblogcasts.com/blogs/jorg/default.aspx

    hth

    Andrew

    Nailed It! Thanks much

  • August 15, 2008 at 7:37 am

    #858718

    scottw (8/14/2008)

    Nailed It! Thanks much

    glad to help

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply