ComfortablyNumb
asked on
SISS: Running 32bit dtexec from Stored Procedure
Hi Experts,
We've just upgraded to SQL Server 2008 and have found that our SSIS packages that import Excel spreadsheets don't work due to the 64bit/32bit issue. I understand I have to run the 32bit version of dtexec to get it to work again, but I can't find how to actually do it.
I have a code snippit from a SP that will show you how I'm currently calling dtexec and the SSIS package.
Any help will be, as always, greatly appreciated.
Regs,
Numb
We've just upgraded to SQL Server 2008 and have found that our SSIS packages that import Excel spreadsheets don't work due to the 64bit/32bit issue. I understand I have to run the 32bit version of dtexec to get it to work again, but I can't find how to actually do it.
I have a code snippit from a SP that will show you how I'm currently calling dtexec and the SSIS package.
EXEC sp_xp_cmdshell_proxy_account 'IIS\xxx', 'password'
EXEC @pc= master..xp_cmdshell 'dtexec /f "F:\SSIS\package1.dtsx"'
Any help will be, as always, greatly appreciated.
Regs,
Numb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
sorry didnt put in the full snippit:
EXEC @pc= master..xp_cmdshell 'c:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dtexec /f "F:\SSIS\ProductCore8.dtsx"'
ASKER
For some reason the SP disnt like the spaces between folder names. Putting "" around them seems to have fixed that...
'c:\"Program Files (x86)"\"Microsoft SQL Server"\100\DTS\Binn\dtexec /f "F:\SSIS\ProductCore8.dtsx"'
ASKER
Thansk for your help x-men. Ya got me sorted!
ASKER
I tried that with :
Open in new window
but get the following error when run:
I know I'm doing something dumb somewhere!
Numb