September 8, 2005 at 9:24 am
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.
September 8, 2005 at 1:20 pm
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