when I ran the SSIS package through the SQL server Agent job I am getting the following error message. Could someone please let me know what it is?
Can we use ODBC connection to run the SSIS packages instead of OLE DB connection?
Message Executed as user: user name. ...0.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:42:08 AM Error: 2008-11-18 11:42:45.79 Code: 0xC0202009 Source: MasterAuto Connection manager "datasource" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". End Error Error: 2008-11-18 11:42:45.83 Code: 0xC020801C Source: Load Master Data Master_PBAT  Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "datasource" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2008-11-18 11:42:45.84 Code: 0xC00470... The package execution fa... The step failed.
This is very likely the case of executing a package that uses an OleDB provider that is registered on the 32 bit hive only. For example, you design a package to use Excel / Access sources. Everything is fine on your 32 bit dev box, but on the x64 server it fails (unless you specify that it needs to run in a 32 bit environment). Please take a look at http://msdn.microsoft.com/en-us/library/ms141766.aspx.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.