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: Yesterday @ 10:14 AM
Points: 30, Visits: 610
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: Today @ 9:28 AM
Points: 5,189, Visits: 12,057
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.
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, October 16, 2014 10:08 PM
Points: 148, Visits: 642
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