Post reply

Getting header columns of excel file in DTS using script

  • May 2, 2007 at 11:23 am

    #69006

    Hi I would like to know if we can get the header columns of an excel file that is the first row of the excel file.

    is there something like DTSSource("Col")

    because DTSSource ("Col") gives the value or the contents of the column specified in the ()

    or anyother suggestions???

    Regards,

    Muhammad Arsalan Ayub
    groups.yahoo.com

    Blog

  • May 3, 2007 at 10:03 am

    #704134

    Is there a static number of columns in the Excel spreadsheet or is this for dynamic transformations?


    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

  • May 3, 2007 at 11:34 am

    #704163

    Yes the number of columns are static,its not a dynamic transformation

    Regards,

    Muhammad Arsalan Ayub
    groups.yahoo.com

    Blog

  • May 3, 2007 at 11:59 am

    #704173

    Try

    DTSSource(1).Name

    DTSSource(2).Name

    etc

    Far away is close at hand in the images of elsewhere.
    Anon.

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

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