Error When Try to Run Package in Job

[mekohler]

Hi, I have created a package that brings in data from another database and with the data package populates a table in SQL database. The job runs fine when it is executed. I've imported it into SQL and it still works fine. But when I try to automate it using SQL Job agent, I get the error that Requested registry access is not allowed, and in the log says:

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {485F9D22-B7A7-446B-BBCB-23706B2624E3} and APPID {83B33982-693D-4824-B42E-7196AE61BB05}

Thanks,
Michael Kohler

 

[fredericofonseca]

have a look at

http://klonkers.blogspot.ie/2013/09/sql-server-2012-integration-services.html

But SQL Server and Integration Services not correctly configured on that server

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[mekohler]

It was the permissions, thanks. I had to add the correct credential to the db_ssiadmin and it works now. Thanks