How to convert a string to date by using only sequential file stage with out using other stages?

at

1 comment:

  1. UnknownFebruary 26, 2011 at 6:57 PM

    1) Open the Sequential file stage properties.
    2) Go to Format > Type Default > Date > Format String.
    3) Type the format of the string in which the source date is coming. For ex. For 20101201 - Type %yyyy%mm%dd.
    4) Go to Column tab, Chose SQl Type as Date.
    Now, try to view data. YOu should be able to see date as 2010-12-01.

    ReplyDelete

Subscribe to: Post Comments (Atom)