execute ssis package in sql server 2008 r2 error

• kpann

  SSC-Addicted

  Points: 423

  More actions

  May 14, 2013 at 1:45 pm

  #277533

  Hi,

  When I executed my SSIS package in BIDS successfully but when I try to schedule to execute my SSIS package in SQL Server Agent and I got this error:

  Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 32-bit. Code: 0XC0209302 Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR. The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. Error Code: 0X00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0X80040154 Description: "Class not registered".

  I already installed the data connectivity components from http://www.microsoft.com/en-us/download/details.aspx?id=23734, set run64bitruntime to false, and checked the "Use 32 bit runtime" in SQL Server 2008. I use SSIS 2008.

  Please help me, thanks.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  May 15, 2013 at 6:37 am

  #1615387

  I believe you need to make sure you are use the 32-bit DTEXEC. Check out this article about 2/3 of the way down.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question