Solved

SISS: Running 32bit  dtexec from Stored Procedure

Posted on 2010-11-30
5
2,202 Views
Last Modified: 2012-08-14
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
0
Comment
Question by:ComfortablyNumb
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
5 Comments
 
LVL 18

Accepted Solution

by:
x-men earned 500 total points
ID: 34238100
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
 

Author Comment

by:ComfortablyNumb
ID: 34238531
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
 

Author Comment

by:ComfortablyNumb
ID: 34238551
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
 

Author Comment

by:ComfortablyNumb
ID: 34238619
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
 

Author Closing Comment

by:ComfortablyNumb
ID: 34238628
Thansk for your help x-men. Ya got me sorted!
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question