Post reply

I have a quick question regarding DTS Excel Sheet Imports

  • March 31, 2005 at 6:22 pm

    #164156

    I have a quick question regarding DTS Excel Sheet Imports

    In one Excel Book I have Multi Sheets Sheet Name Based on the Sales Date Like 0104-1st of March ,0803 8th of  March

    Sample March Excel Sheet   0103,0803

    When I upload the excel sheet  weekly, I need to imports the date from Latest sheet (0803)

     

     

    Thanks In Advance

    Best Regards

    Vijay

  • March 31, 2005 at 8:06 pm

    #549975

    If the structure of the sheet remains the same for each sheet, you can change the name of the source easiliy enough using a dynamic properties task. The tricky part would be determining the latest sheet based on the name.

    Maybe this could be done with and ADO connection in an ActiveXScript Task. From memory I think there is an method called OpenSchema which returns a resultset containing the sheet names. If my thinking is on the right path, you could play with this resultset to work out the latest one and then assign the name to a global variable. Then you would use the global variable in the Dynamic Properties task.

     

    --------------------
    Colt 45 - the original point and click interface

Viewing 2 posts - 1 through 1 (of 1 total)

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