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 Tuesday, April 22, 2014 6:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 11, 2014 9:03 AM
Points: 4, Visits: 36
I am able to run the SSIS package just fine by itself, and I am using my sql account. The issue happens when I add it to the SQL server agent to execute, that's when my package fails.

Any thoughts?

amirhh2000 (3/24/2014)
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 #1563824
« Prev Topic | Next Topic »

Add to briefcase «««23456

Permissions Expand / Collapse