<div>
try using C:\Progra~1 insead of the long name. &nbsp;The space between Program and Files is likely your issue.<br />

</div>


try using C:\Progra~1 insead of the long name.  The space between Program and Files is likely your issue.


<div>
Oh, and that was a copy and save, not a rename...
</div>


Oh, and that was a copy and save, not a rename...

<div>
A pleasure, and thanks for the &quot;Thank You&quot; always enjoy hearing those two words :)
</div>


A pleasure, and thanks for the "Thank You" always enjoy hearing those two words :)

<div>
<div class="content wysiwyg-content">
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:<br />
<br />
'C:\Program' is not recognized as an internal or operable program or batch file<br />
<br />
I know its something stupid..but i can't figure it out...here is the code:<br />
<br />
exec master..xp_cmdshell '&quot;C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.<wbr />exe&quot; /F &quot;C:\One2OneUS\SSISPackages<wbr />\SQL01One2<wbr />OneUSToGen<wbr />Lookup.dts<wbr />x&quot;'<br />
<br />
Any help would be greatly appreciated...<br />
<br />
Regards<br />
Mark
</div>
</div>


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

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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.