July 25, 2006 at 7:37 am
SQL Server 2000
I have created a DTS package on a server and tested it interactively on the server in EM by right-click / Execute Package, while logged in as the same user as the SQL Agent service runs under. Works great.
This is a job that I would like to run every day, so I created a job by right-clicking on the package and selecting Schedule. After setting up the schedule that I wanted, I decided to test the DTSRun job by right-click / start job. This time it fails, telling me that I need to register a certain class (application specific - may not mean much to people here).
My question is, what difference between running the package interactively and running the job interactively could be causing an error in one case and not the other?
Many thanks.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 26, 2006 at 5:41 am
The DTS package runs on the client PC and the job runs on the SQL server.
Try logging in on the SQL server (console) with the SQL Service Agent user account and then execute your package. That should create the same error caused by the job. Also, change your job to execute the following command: DTSRun /S SERVER_NAME /E /N PACKAGE_NAME
I have found problems using the right-click schedule option. It has something to do with package versions.
5ilverFox
Consulting DBA / Developer
South Africa
July 26, 2006 at 8:03 am
OK, will try your (more helpful) syntax.
I was on the server (via RDP) and I was logged in as the SQL Agent service user when I got the error, so that's not the answer. I know, strange.
Thanks
Phil
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply