Groups | Blog | Home
all groups > sql server dts > may 2006 >

sql server dts : calling DTS package from sp gives an error



jtammyg NO[at]SPAM yahoo.com
5/17/2006 7:27:07 AM
Hi!

I am running a sp which calls a DTS package at the end with following
code:

EXEC Xp_Cmdshell 'DTSRUN /E /NERROR_FILE_PROVIDERS'
GO

After I run the sp it gives me this error message:

Server: Msg 2812, Level 16, State 62, Line 124
Could not find stored procedure 'Xp_Cmdshell'.

What am I doing wrong?

Any help would be greatly appreciated.

TG
TG
5/17/2006 8:23:13 AM
fixed.

it should be

EXEC master.dbo.Xp_Cmdshell 'DTSRUN /E /NERROR_FILE_PROVIDERS'
AddThis Social Bookmark Button