Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rach2009
Starting Member
37 Posts |
 Posted - 2010-03-01 : 09:34:51
|
| Hi All,I am trying to schedule a SSIS Package using SQL Server Agent, but whichever combination of protection I try, it still continues to fail. I get the following error message:-Error: 2010-03-01 13:56:01.08 Code: 0xC0202009 Source: new version Connection manager "SourceConnectionOLEDB" 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: 2010-03-01 13:56:01.08 Code: 0xC020801C Source: Data Flow Task Source - Query [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Sorry its so long! Any ideas whay this might be happening? Any suggestions for how I can solve this problem?ThanksRachel |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-01 : 10:24:27
|
| whats the version of SSIS installed? are you able to execute packages independently?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Rach2009
Starting Member
37 Posts |
Posted - 2010-03-01 : 10:27:53
|
| Im using SQL Server 2005. Yes, packages work fine when run independently of the Agent |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-01 : 10:29:58
|
| sorry i asked you version of ssis (business intelligence studio/visual studio)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Rach2009
Starting Member
37 Posts |
Posted - 2010-03-01 : 10:45:29
|
| I'm not sure sorry - where would I find the version number? I'm not currently using the Business Intelligence Studio - just creating packages through the import/export wizard.Many Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-01 : 11:07:57
|
| then look into about option of ssms------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Scheduling SSIS Packages SQL Server Agent