February 24, 2009 at 6:19 am
Hi folks
I have a number of DTS packages that run nightly under SqlAgent jobs, all they do is copy data between Sql Server databases. These have been running fine, up until last night. The IP addresses were changed yesterday on some of the Sql Server boxes, and now, while the packages run fine if I right-click/execute, the jobs themselves fail.
If I create a new job for the DTS packages via right-click/schedule package (which was how the original jobs were created as far as I can tell), and then execute this job, it runs with no problems at all.
All the connections within the packages reference DNS names and not IP Addresses, so that's not the problem.
I'm at a loss as to what to look into next, any thoughts would be very much appreciated
The actual error returned is:
DTSRun: Loading... Error: -2147467259 (80004005); Provider Error: 17 (11) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0. Process Exit Code 1. The step failed.
but I don't understand how this can be an issue, given everything else mentioned above
February 24, 2009 at 10:58 am
I think I know what's going on.
I haven't dealt with Sql2000/DTS for a while now, and had forgotten that DTS keeps previous versions of msdb packages
So the DtsRun commands within the jobsteps are still pointing to the previous versions of the packages, which of course reference the now invalid IP addresses
February 24, 2009 at 11:22 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply