Post reply

DTSRUN hangs when executed through xp_cmdshell

  • September 8, 2005 at 9:24 am

    #91067

    Hi,  I'm new at this, so go easy on me!  I'm having a problem trying to execute a dtsrun command through the xp_cmdshell extended stored procedure.  The package executes just fine when I run it with DTS or at a DOS prompt, just not when I run the script.  The session just hangs up, and I have to reset it from the console.  I'm using SQLServer 2000 (not sure which SP, the version comes back 8.00.76) on Windows 2000.  The script is below:

    USE Master

    EXECUTE xp_cmdshell 'dtsrun /S (local) /E /N PS010ATransfer'

    I have tried numerous variations on the command syntax, but nothing seems to work.  This is driving me nuts, so please help!  Thanks.

    I forgot to mention that the DTS package is transferring a file from an AS400 to SQL and creating a table.  It's not doing anything with the data, just transferring it.

    Dan Moyer
    IS Staff
    Stanley Electric U.S. Co., Inc.

  • September 8, 2005 at 1:20 pm

    #588523

    To run DTSRUN with xp_cmdshell require SQL Server Agent installed with a Service account.  Try the links below for configuration information.  Hope this helps

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_4jxo.asp

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_8sdm.asp

    Kind regards,

    Gift Peddie

    Kind regards,
    Gift Peddie

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

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