calling DTS package from sp gives an error

#1

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

#2

fixed.

it should be

EXEC master.dbo.Xp_Cmdshell 'DTSRUN /E /NERROR_FILE_PROVIDERS'

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

calling DTS package from sp gives an error

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

calling DTS package from sp gives an error - 05-17-2006 , 09:27 AM

Re: calling DTS package from sp gives an error - 05-17-2006 , 10:23 AM