November 2, 2005 at 9:40 am
I've had a DTS package running through a scheduled job for months. A few days ago I edited the package and now it will not run. The job step uses dtsrun and gets an unspecified error. If I use dtsrunui from a command line I get a message referring to the owner password (there is none). If I use Enterprise Manager the package executes just fine. Any ideas?
November 3, 2005 at 4:04 am
The Problem could be with the New package ID that was created when the DTS package was edited and saved. DTS will not allow you to execute a package, if there's a chance it'll execute the wrong package. To ensure that you always execute the proper package, you can use the /G switch which contains the GUID for that packate. You can find the Packate's GUID by selecting [Package Properties] under the package menu. Verify if the GUID in the DTS scheduler matches the recent version's GUID.
You could also experiment using the Package's name in the DTSRUN command by using the [/N Package_Name] switch instead of the GUID.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply