Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
supersql
Yak Posting Veteran
99 Posts |
 Posted - 2006-03-02 : 07:51:56
|
| 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. |
|
|
|
|
|
Load file