Post reply

SSIS-Fast Parse

  • March 23, 2012 at 8:12 am

    #1463418

    Thank you for the nice and easy question, I agree the article on the link Babu provided would have been more appropriate.

    Have an excellent weekend, everyone.

    "El" Jerry.

    "El" Jerry.

    "A watt of Ottawa" - Gerardo Galvan

    To better understand your help request, please follow these best practices.[/url]

  • March 23, 2012 at 8:47 am

    #1463441

    good question to round out the week - cheers

  • March 23, 2012 at 9:12 am

    #1463468

    Got it right, even though it was an (educated) guess. My work with SQL Server introduced me to the YYYY MM DD date order, and to me it's the most logical way to format a date (as long as you're constrained by the somewhat illogical units of years, months (especially) and days.)

    Digit by digit, it goes from least specific to most specific (left-to-right). With fixed-length fields, you can easily parse it to a string, an integer, an array, etc. Also since the fields are fixed-length, the choice (or lack) of a separator does not significantly increase ambiguity (athough having no separator can make some dates more ambiguous.)

  • April 2, 2012 at 7:05 pm

    #1467988

    Excellent question. Thanks for submitting.

    http://brittcluff.blogspot.com/

Viewing 4 posts - 16 through 18 (of 18 total)

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