Post reply

NewBie: How to format (zero padding, datetime) the columns of a table to output it to a flat file

  • September 28, 2009 at 11:42 am

    #210203

    Hi All

    Could someone pls tell me how I can retrieve columns from a table, format (zero padding, datetime) the columns to output it to a flat file.

    I can access the table through the OLE DB Source. But I dont want to make any changes to the original file.

    Thankyou

    Gomathi

  • September 28, 2009 at 12:45 pm

    #1059153

    You could change your OLE DB source to use a SQL Command, then write a query that does your date formatting and zero-padding, or you could leave the source as is and add a Derived Column component to do it.

  • September 28, 2009 at 1:09 pm

    #1059164

    Hi

    The problem I m facing is how to map the output of my OLE DB COMMAND to the flat file destination ?

    Thanks

    Gomz

  • September 29, 2009 at 8:50 am

    #1059522

    Hi I fixed my problem.

    Instead of using a OLE DB Command , I used an OLE DB Source - configured the source to access a stored procedure that executes my select statement. Once I got it hooked to a flat file destination I was fine.

    Thanks anyways. Hope this helps someone.

    Gomz

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

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