June 23, 2008 at 2:28 pm
I have a SQL Server 2000 job.
The second step is:
EXECUTE master.dbo.xp_cmdshell 'dtexec /f e:\ssis_packages\Niad.dtsx'
which returns an error in QA:
'dtexec' is not recognized as an internal or external command,
.....
But when I login to that server and run the same command from
DOS it works. Why it doesn't recognize DTEXEC command in T-SQL?
Even
EXECUTE master.dbo.xp_cmdshell 'dtexec /?'
fails.
June 23, 2008 at 2:48 pm
Google helps.
Here is one:
HTH.
June 24, 2008 at 7:12 am
Article doesn't help.
I have new details now.
I actually logged to the target server
and ran this command:
EXECUTE master.dbo.xp_cmdshell '"C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTexec.exe "'
It recognizes the utility. The output is:
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.3042.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
NULL
At least one of the DTS, SQL, or File options must be specified.
But when I add "/f" it throws me an old error:
'C:\Program' is not recognized as an internal or external command,
In DOS the output is:
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.3042.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Missing argument for option "file".
So what we have now?
DTEXEC is being recognized. But when adding more to the command
something breaks. Maybe I should play around with single quotes + double quotes?
June 24, 2008 at 7:37 am
I am moving this topic to SSIS Forum...
June 28, 2008 at 11:20 pm
[font="Verdana"]Hi,
The path you have used above is not added in environment variable thus you are getting the error. Add that binn folder to your environment variable, hence going forward you can use the utility without mentioning the path![/font]
Regards..Vidhya Sagar
SQL-Articles
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply