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 |
|
dletz
Starting Member
2 Posts |
 Posted - 2008-03-25 : 10:11:14
|
| I am new to this, so please bear with me. I have a DTS job set up that finds an excel file on a network drive (I use a UNC path) and imports the data to a SQL table. The job ran just fine the first time around. Although the file name remains the same (it is updated every month) the DTS job failed the next time. I looked in the Source tab of Transform Data Task Properties, and the name of the "Table/View" was no longer valid. As a mater of fact, DTS added a new name for the "Table/View" in the drop-down list. Funny thing is, the source is an excel file, not a table or view. Why is DTS doing this? I have another DTS job that imports a text file, and in the "Table/View" it shows the UNC path that I established in the Source connection for that text file. I was expecting DTS to do the same (show a UNC path to the excel file as the "Table/View").Hopefully I have adequately described the problem. Thanks in advance for your replies. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-25 : 22:59:13
|
| Enable package logging to find out why the package failed. |
 |
|
|
dletz
Starting Member
2 Posts |
Posted - 2008-03-26 : 08:51:34
|
| Actually, I discovered that the person who replaces the file each month was naming the worksheet something different. After I had them name the woprksheet the same as the previous month's file, all is well.Thanks for your reply. |
|
|
|
|
|
|
Transform Excel to SQL Server