Error running dtexec in 32 bit on sql2005 x64 from stored proc

I am receiving the following error when i am trying to run an SSIS package in 32 bit mode from a stored procedure in sql 2005:

'C:\Program' is not recognized as an internal or operable program or batch file

I know its something stupid..but i can't figure it out...here is the code:

exec master..xp_cmdshell '"C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /F "C:\One2OneUS\SSISPackages\SQL01One2OneUSToGenLookup.dtsx"'

Any help would be greatly appreciated...

Regards
Mark
metseyAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Mark WillsConnect With a Mentor Topic AdvisorCommented:
It is the two groups of quoted strings... Try :

exec master..xp_cmdshell '"C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /F C:\One2OneUS\SSISPackages\SQL01One2OneUSToGenLookup.dtsx'

Or, simple make sure DTEXEC is part of the PATH and simply run :

exec master..xp_cmdshell 'DTExec.exe /F "C:\One2OneUS\SSISPackages\SQL01One2OneUSToGenLookup.dtsx"'

The trouble in 64 bit is that there is a 32 bit and a 64 bit version of deexec. The way we "fixed" that for batch jobs was to copy and save each as DTEXEC32 and DTEXEC64 respecitively - not really a good thing to do, but solved a heck of a lot of problems for our batch jobs !!
0
 
randy_knightCommented:
try using C:\Progra~1 insead of the long name.  The space between Program and Files is likely your issue.
0
 
Mark WillsTopic AdvisorCommented:
Oh, and that was a copy and save, not a rename...
0
 
metseyAuthor Commented:
Thank you sir
0
 
Mark WillsTopic AdvisorCommented:
A pleasure, and thanks for the "Thank You" always enjoy hearing those two words :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.