SQL Server Performance

Load Excel

Discussion in 'SQL Server DTS-Related Questions' started by Reddy, Mar 2, 2006.

  1. Reddy New Member

    I am loading an excel file into sql table using sql DTS, which is a sheduled job. My job is looking for test.xls and that excel file has test20060301 as sheet1 and the name of the sheet1 will be changing every day according to date, because of which my sheduled job is failing to load. How can I resolve this so that my DTS job loads the file though the name of the sheet is changed.

    Thanks!
    "He laughs best who laughs last"

Share This Page