Home Forums SQL Server 2005 SQL Server 2005 Integration Services Data conversion in SSIS RE: Data conversion in SSIS

  • December 8, 2012 at 10:53 pm

    #1566863

    Ray M (12/7/2012)

    My First question would be what have you tried, and where are you getting stuck.

    I gave you your first Clue.

    I suspect your next issue will be that since its DD/MM/YYYY formatted your data will not be correct so you'll need to do some string manipulation.

    Here's a nice article

    http://toddmcdermid.blogspot.com/2008/11/converting-strings-to-dates-in-derived.html#!/2008/11/converting-strings-to-dates-in-derived.html

    But doesn't necessarily give you your answer. Clue use Substring to re-format the string into MM/DD/YYYY (Or YYYYY-MM-DD and concatenate your time value by adding + " " + EVENT_T

    Thanks the link u posted helps! I get where u are coming from. Wonderful work. As for where am i stuck? Now currently i am still at the understanding of my source data and designing my target table phase. I post this qns becuz i am worried of the data type conversion. . I understood my data but currently i am now stuck at how to derive my target table(the logic). It just seems impossible to do it through SSIS. Some1 told me make use of staging tables, I read on that but still clueless. Do you want to take a look?? or should i start a new thread?

    Thanks for being so helpful. At least now i know, my date and time column could be converted.