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.

EXEC sp_xp_cmdshell_proxy_account 'IIS\xxx', 'password'
EXEC @pc= master..xp_cmdshell  'dtexec /f "F:\SSIS\package1.dtsx"'

Open in new window


Any help will be, as always, greatly appreciated.

Regs,
Numb
ComfortablyNumbAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
x-menConnect With a Mentor IT super heroCommented:
as simple as: (make sure you get the full path right ;) )

EXEC @pc= master..xp_cmdshell  'c:\Program Files (x86)\...\dtexec /f "F:\SSIS\package1.dtsx"'
 
0
 
ComfortablyNumbAuthor Commented:
Hi x-men,

I tried that with :

'c:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dtexec /f "F:\SSIS\package1.dtsx"'

Open in new window


but get the following error when run:

'c:\Program' is not recognized as an internal or external command,
operable program or batch file.
NULL

I know I'm doing something dumb somewhere!

Numb

0
 
ComfortablyNumbAuthor Commented:
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"'

Open in new window

0
 
ComfortablyNumbAuthor Commented:
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"'

Open in new window

0
 
ComfortablyNumbAuthor Commented:
Thansk for your help x-men. Ya got me sorted!
0
All Courses

From novice to tech pro — start learning today.