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.