December 4, 2008 11:29pm pst

1. chapmandew 148,510
2. acperkins 123,155
3. nmcdermaid 112,817
4. mark_wills 85,302
5. cs97jjm3 64,614
6. PedroCGD 47,980
7. angelIII 43,760
8. brejk 36,600
9. EugeneZ 36,222
10. HoggZilla 29,300
11. frankytee 27,691
12. dready 20,000
13. matthews... 19,550
14. Zberteoc 18,300
15. bhess1 16,550
16. aneeshatti... 14,002
17. rickchild 13,750
18. momi_sa... 13,514
19. dtodd 10,582
20. rboyd56 10,525
21. MohammedU 10,325
22. dbaSQL 9,815
23. Yveau 9,700
24. jimhorn 9,100
25. Wizilling 9,032

1. acperkins 391,404
2. nmcdermaid 225,534
3. angelIII 184,176
4. arbert 149,684
5. chapmandew 148,510
6. EugeneZ 87,040
7. mark_wills 85,302
8. cs97jjm3 71,144
9. matthews... 57,604
10. PedroCGD 49,480
11. aneeshatti... 47,999
12. rboyd56 42,625
13. ptjcb 38,638
14. brejk 36,600
15. bhess1 36,130
16. twoboats 30,515
17. frankytee 30,441
18. dready 30,430
19. Yveau 30,000
20. HoggZilla 29,300
21. Sirees 27,902
22. jltoops 27,275
23. Zberteoc 25,200
24. Wizilling 24,832
25. Lowfatsp... 24,059

11.15.2007 at 07:42AM PST, ID: 22963124

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.0

Cannot exexute SSIS package on sql 2005 from job on 64 bit server - Class not registered

Asked by edjones1 in MS SQL DTS, MS SQL Server, SQL Server 2005

Tags: error, ssis, code

Hi

I'm trying to get a SSIS package to run from a sql server agent job but it won't becase I heep getting the below error. I can run the package manually but it won't run from a job and I get the same error when I try to execute it from a DOS command too from a local directory on the server.

Eg

dtexec /F "C:\CommTrak\CTI.dtsx"

I know its somthing to do with the sql server being on a 64 bit computer but just can't work out how to make it run from a job or batch file.

==============================================
error

09/10/2007 16:38:53,NewCTimport,Error,1,SQL36,NewCTimport,NewCTImport,,Executed as user: SQL1\Administrator. ...9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 4:38:53 pm Error: 2007-09-10 16:38:57.45 Code: 0xC0202009 Source: NewCTImport 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: 2007-09-10 16:38:57.45 Code: 0xC020801C
Source: Data Flow Task Source - qryLenderCriteria [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009.

==================================================================================================Start Free Trial

         
             ==============================================
error
 
09/10/2007 16:38:53,NewCTimport,Error,1,SQL36,NewCTimport,NewCTImport,,Executed as user: SQL1\Administrator. ...9.00.3042.00 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  4:38:53 pm  Error: 2007-09-10 16:38:57.45     Code: 0xC0202009     Source: NewCTImport 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: 2007-09-10 16:38:57.45     Code: 0xC020801C     
Source: Data Flow Task Source - qryLenderCriteria [1]     Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009.
 
==================================================================================================

Keywords: Cannot exexute SSIS package on sql …

	Title
1	From DTS to SSIS
2	Trying to Query 'Active Directory' in…
3	How to Deploy and Execute SSIS pack…
4	change data driven query of DTS to SS…
5	How can I put the name of my SSIS pa…
6	Can't find SSIS

Loading Advertisement...

20081112-EE-VQP-43 / EE_QW_2_20070628

Cannot exexute SSIS package on sql 2005 from job on 64 bit server - Class not registered

Asked by edjones1 in MS SQL DTS, MS SQL Server, SQL Server 2005

Tags: error, ssis, code

About this solution