Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««23456»»

SSIS, "Class Not Registered" error...deployment or permissions issue? Expand / Collapse
Author
Message
Posted Wednesday, March 17, 2010 10:01 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 2:44 PM
Points: 30, Visits: 620
By reading lots of links and finally got mine working.
My issue was connected to a 32bit Access database from 64bit SQL server running as a job and it throw Code: 0xC0202009 , Error code: 0x80040154 and "Class not registered".

For debugging, I changed the debugging option "Run64BitRuntime" to False.
To fix the scheduled job with package saved in SQL server, I modified the step to use the 32bit DTExec.exe and as Type of Operating Ssystem (cmdExec) to be something like this

"D:\Program Files\Microsoft SQL Server (x86)\90\DTS\Binn\DTExec.exe" /SQL "\packageNameInMSDB" /SERVER CQDSC01 /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E
http://msdn.microsoft.com/en-us/library/ms162810.aspx - Great link for dtex.exe
Post #884835
Posted Thursday, April 15, 2010 7:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 23, 2011 4:34 PM
Points: 1, Visits: 34
Hi SSC-Enthusiastic

When all started working for you... where you running it as a SSIS or Operating system (64-bit or 32-bit)?

Thanks
Post #904523
Posted Friday, May 14, 2010 4:42 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, May 21, 2012 3:52 PM
Points: 14, Visits: 87
This article was a great help. I had a few SSIS packages that were falling over and reading this article helped me figure it out.

Thanks a lot guys =o)

Post #921900
Posted Wednesday, December 1, 2010 9:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 27, 2013 1:40 PM
Points: 7, Visits: 100
I recently came across the same problem and changing the max concurrency to 1 seemed to fix my problem. Hope this help!

/MAXCONCURRENT " -1 "


Thanks,
Jeff M. Belina
Sr. Database Developer/DBA
Post #1028751
Posted Wednesday, December 1, 2010 9:15 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:15 AM
Points: 5,317, Visits: 12,354
jbelina (12/1/2010)
I recently came across the same problem and changing the max concurrency to 1 seemed to fix my problem. Hope this help!

/MAXCONCURRENT " -1 "


Your text states '1' and your sample code '-1'. Which did you intend?



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.

It is better to keep your mouth shut and appear stupid than to open it and remove all doubt. (Mark Twain)
Post #1028763
Posted Tuesday, January 11, 2011 1:15 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 18, 2014 5:25 AM
Points: 148, Visits: 647
Where in package properties, do I set run In 64bit = false?
Post #1046120
Posted Wednesday, May 11, 2011 11:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 14, 2013 2:31 PM
Points: 5, Visits: 87
After going thru the long list of replies I tried to run it thru CMD
I modified the job to use cmdexec step and : C:\Program Files (x86)\Microsoft SQL Server\90 \DTS\Binn\DTExec.exe /f "Package Path" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EW

And it executed just like you are having a piece of Cake.

Thanks for the Inputs.

Post #1107214
Posted Friday, May 27, 2011 2:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 27, 2011 4:53 AM
Points: 1, Visits: 5
Hi I am Ramesh from Chennai, India.

I am also facing the same problem but I am using data source as Excel file. Error displayed as below...

FirstLine:
"[Excel Source [17]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009"

SecondLine:
[Connection manager "Excel Connection Manager"] Error: 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".

Can any one help me....?
Post #1116064
Posted Tuesday, March 19, 2013 1:46 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, June 26, 2014 11:50 AM
Points: 15, Visits: 55

Thanks for the info on set 64bit run to false, that fixed my SSIS issues!
Post #1432882
Posted Monday, March 24, 2014 7:26 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 23, 2014 12:39 AM
Points: 18, Visits: 98
First of all I hate SSIS2005 ... it has too many bugs ... (preferably use 2008R2 or 2012)

Things you can check are as follows:

1. Make 64bit false
2. Delay validation = False (in the body of package and on all objects)
3. EncreptionMethod = SensitiveWithPassword
4. If you changed number 3 reopen your data connections and re enter username password to be encrypted with the new method.
5. SQL Agent Service account has access to your Excel/Access datafile location
6. Create the SQL Job from SSMS2005 not SSMS2008/2012
7. be patient ... :)

Cheers
Amir
Post #1554259
« Prev Topic | Next Topic »

Add to briefcase «««23456»»

Permissions Expand / Collapse