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 |
|
mythodea
Starting Member
3 Posts |
 Posted - 2005-10-06 : 05:33:35
|
| I have created a DTS package which imports data from an excel file into a db table. The package works just fine, but when I try to schedule this package, the job fails.A DTS package which imports data from a text file can be scheduled without problem.I cannot find any solution and the scheduled package does not create entries in the specified package error log file.Have you any ideas?Thanks |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2005-10-06 : 06:02:10
|
| Are you definitely logging the package's execution? (package-->properties-->logging tab-->log package execution to SQL Server)Mark |
 |
|
|
mythodea
Starting Member
3 Posts |
Posted - 2005-10-06 : 07:40:13
|
| Yes definitely. When I execute the package the log file has an entry:"The execution of the following DTS Package succeeded:etc....."The job always fails without any entry in the package log fileAntonio |
|
|
|
mythodea
Starting Member
3 Posts |
Posted - 2005-10-17 : 04:48:09
|
| Finally I found the problem. Excel libraries need to be installed, in order to be able to schedule the Job!!! |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
MS excel import job does not run