December 20, 2004 at 7:15 am
Hey gurus,
Quick Question. I'm running a DTS Package that imports data from a db4 database into a SQL Server database. If I run the package right from EM everything works great. When I try to run the package through QA using the syntax below I get an error:
Syntax:
DECLARE @DTS_PACKAGE VARCHAR(1000)
SET @DTS_PACKAGE = CHAR(34) + 'DTSRUN /S SERVERNAME /E /N "DTS_PACKAGE"' + CHAR(34)
EXEC master..xp_cmdshell @DTS_PACKAGE
Error string:
'File Path' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
If I open a cmd console I can hit that folder without error. Does anyone have any quick suggestions that I can try? I have no idea what the problem could be.
Any help would be really appreciated. Thanks
Shane
December 20, 2004 at 1:17 pm
Are you executing the DTS package from EM on the same machine as the db server? If you manualy execute from your local machine the package acctually executes on your machine. Thus, you have a permisions problem. When you execute with xp_cmdshell you will be using the permisions your sql server is running under. For more information read the "Remarks" section for xp_cmdshell in BOL.
Hope this helps...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply