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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-29 : 12:12:54
|
| Barbara writes "I created a DTS package. The source is a MYSQL database that I am connecting to via myodbc. The destination is SQL Server 2000 database with SP2. When I execute the package from enterprise manager, it runs just fine. When I schedule the job, it fails. I have created other DTS packages where both the source and destination are the same SQL Server 2000 database and they will execute when scheduled. I have also successfully schedule packages where the source is one SQL Server 2000 database and the destination another. These also execute when scheduled. When I run the problem DTS package from enterprise manager, I am logged into the server as administrator. Both the SQL Server service and the SQL SERVER AGENT service are running using the local system account. The package and job are both owned by NT administrator account. We do not have a domain controller so the SQL server is just a workgroup system. The message that I get on failure is as follows:"The job failed. The Job was invoked by User SERVER\USERNAME. The last step to run was step 1 (stepname)."I think that the problem is probably either a permissons/security issue but have not been able to figure out where. I hope you don't consider this a MySQL issue as I do not want to waiste your time. Any help would be appreciated.Thanks" |
|
|
|
|
|
Scheduled DTS package fails when source is ODBC link to MySQL database