DTS Package executes manually but fails as scheduled job to run

Hi,

I have a DTS package which when I execute it manually, it executes perfectly. I need to schedule it and therefore had to use the scheduler which would creata a job for the package. The problem is that job. It does not execute; it fails every time. The error message is: Sql server does not exist or access is denied.

I have tried to trouble-shoot by setting up an alias for the server in the client network utility for sql server. I also create a new dsn with the new alias. It still failed with the same error message. I edited the properties of the dts package to connect to the server's ip instead of it's alias or logical name. Still fails.

Any ideas anyone?

Maria

The error is telling you it can't find or connect to the sql server you have specified in the DTS package.

I understand what it means. I just don't understand why it runs as a package and yet as a job it doesn't. Why can't it connect? That is the issue and of course, if anyone has experienced something similar.

Maria

Any files the package needs should be on the database server. The SQL Server services should start up with a domain account that has local admin privileges. Both of these items should be true in order to run a DTS package as a scheduled job.