Post reply

I want ot pick excel file dynamicaly for data flow in ssis

  • April 4, 2008 at 4:03 am

    #120912

    Hi,

    I am using BIDS2005 for SSIS. I want to make a package that automatically pick the excel file name and sheet name from a specific directory.

    Suppose i have a file example.xls , which has two column name and code. This file is in the directory "C:\d1\". Every day file name will be changed as requirement i want to pick the file name and sheet name automatically by the package while running. I think i should not bother about column because column will same every time so no need to change the mapping.

    can it possible, if yes please suggest me with the steps i should follow.

    Thanks,

    Dpak

  • April 4, 2008 at 4:14 am

    #798295

    Check this link. You may get some pointers from there:

    http://www.sqlis.com/55.aspx

  • April 11, 2008 at 12:25 am

    #801300

    Thanks Girish, it was really helpful. It is fine for the text file, but when i am trying to change the excel source through variable , it gives error.

    Can you please suggest me how to set variable as connection sting and sheet name using excel source.

    Thanks,

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

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