How to execute a package in 32-bit mode using dtexec.exe?

Question

I have created SSIS Package (.dtsx) which is stored on my hard drive. I want to execute it by using command prompt utility.

It is created in 64 bit environment and uses Excel Connection Manager (JET provider). Hence cant execute it as 64 bit.

I want to execute it in 32 bit. Does command prompt have this option like GUI has ?

C:\Users\Administrator>dtexec.exe /FILE "C:\Program Files (x86)\AGSFeedReaders\ICICISendEmail.dtsx" /DECRYPT "<password>" /X86  /CHECKPOINTING OFF /REPORTING E

Error :-

   Description: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.

Can I execute same in 32 bit mode using command prompt ?

The [documentation](http://msdn.microsoft.com/en-us/library/ms162810(v=sql.105).aspx) explains how to install and use the 32-bit version of dtexec.exe alongside the 64-bit version. Is it unclear in some way? — Pondlife, Dec 19 '12 at 14:22

score 2 · Accepted Answer · answered Dec 19 '12 at 14:24

2

You can install a 32-Bit Version of dtexec.

http://msdn.microsoft.com/en-en/library/ms162810(v=sql.105).aspx

answered Dec 19 '12 at 14:24

bummi

27,123
14
62
101

How to execute a package in 32-bit mode using dtexec.exe?

1 Answers1

Linked