MS SQL Server DTS - DTSRun works at command line but not from script--help

Author

DTSRun works at command line but not from script--help

cfreitag

2005-09-27, 1:23 pm

I am attempting to run a DTS package from a SQL script.
When I run this:
EXEC master.dbo.xp_cmdshell 'DTSRun.exe /S <mylocalserver> /E /N "PM DWH
Master" /A @RunDate:7=10/10/2005'

I get this error:
Error string: Login failed for user '(null)'. Reason: Not associated with
a trusted SQL Server connection.

But if I run the same command string from a command line, it runs perfect.
Any suggestions? I'm new to DTS and this is driving me crazy.

cfreitag

2005-09-27, 8:24 pm

NEVERMIND. It appears that the logging on my local package was pointing to
our development server. I switched it to my local server and now it works
fine.

"cfreitag" wrote:

> I am attempting to run a DTS package from a SQL script.
> When I run this:
> EXEC master.dbo.xp_cmdshell 'DTSRun.exe /S <mylocalserver> /E /N "PM DWH
> Master" /A @RunDate:7=10/10/2005'
>
> I get this error:
> Error string: Login failed for user '(null)'. Reason: Not associated with
> a trusted SQL Server connection.
>
> But if I run the same command string from a command line, it runs perfect.
> Any suggestions? I'm new to DTS and this is driving me crazy.

Sponsored Links