Post reply

CALL DTSRUN THRU XP_CMDSHELL ANYONE ??

  • October 23, 2001 at 11:33 am

    #104595

    can anyone post an example of how to call dtsrun thru xp_cmdshell ?

  • October 23, 2001 at 11:48 am

    #419209

    A very simple way to get this pattern is to right click on a dts package using enterprise manager and selecting schedule a job. This will build a dtsrun command string. The caviat is that this is a series of guids built that include your 'version' of the package. If you alter the dts package you will need to repeat and replace the new string into your scheduled job.

    Example string built: DTSRun /~S 0x0E053E075B1EB77B1C60F63A828E2E15C008C528661BD417 /~N 0x3FB6EE04EE88B29D14D4EB10556050C556204D3482855A0F41D7BBF32885D393671A8356D87C99B6928FE3D626F74F7E02A0A92AFFE2AA08 /E

    Jody

  • October 23, 2001 at 11:56 am

    #419211

    master.dbo.xp_cmdshell 'DTSRun /Sservername

    /Npackagename /Uusername /Ppassword'

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply