July 3, 2002 at 6:53 am
Hi there.
I have set up a DTS package as a scheduled job. The problem is that it returns an error when executes and does not perform the job.
The package is located on a SQL Server on my webhotel (which I access across the Internet from the Data Scource machine). I have used a UserDNS which was created on the Database Source machine. The Data Source machine has access to the Internet via a LAN connection through a server with fixed IP address.
It would seem the package is not able to connect to the local server and locate the Data Source on the client machine.
What am I doing wrong, any ideas?
/Bakkegaard
July 3, 2002 at 10:17 am
You need a system datasource. The SQL package runs under the SQLAgent account, which will not see your user DSN.
Steve Jones
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply