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...