SSIS 2012: package executing successfully from agent job but throwing error when executed directly from catalog

Question

SSIS 2012: package executing successfully from agent job but throwing error when executed directly from catalog

psingla

Hall of Fame

Points: 3840
More actions
August 13, 2015 at 1:11 am

#306805

I have a package deployed in SSIS 2012 catalog. It is working fine when called from agent job but when it fails when called directly from catalog.
The package is failing on script task which is trying to create a directory.
other info:
1) I am using same account for executing the package from job and directly.
2) The account has all the necessary permission on the folder
3) I tried running the package in 32 bit mode
4) I tried redeploying the package
But none of the above worked for me.Any help would be much appreciated.
Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

psingla Hall of Fame Points: 3840 More actions · Answer 1

following is the link of the discussion that I had with Arthur on MSDN forum

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/aeae8732-964c-4d9a-9255-b2c2584e572a/ssis-2012-package-executing-from-agent-job-but-throwing-error-from-catalog?forum=sqlintegrationservices

Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/

sickb00000y Old Hand Points: 313 More actions · Answer 2

If you are running an Integration Services package from within Management Studio, it's going to run under the account you connect to the server with via SMSS, but when you run the SQL Server Agent job from Management Studio, it will run under the SQL Server Agent account.

The scenario you described was almost the same as the one I found only two days after starting a new job. Make sure the account you are using to connect to the server has the appropriate permissions in the parent folder, and then run the SSIS package again.

psingla Hall of Fame Points: 3840 More actions · Answer 3

i am using proxy account in the job and its the one which i am using to connect to the catalog.

Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/

Brandie Tarvin SSC Guru Points: 173053 More actions · Answer 4

psingla (8/13/2015)
following is the link of the discussion that I had with Arthur on MSDN forum
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/aeae8732-964c-4d9a-9255-b2c2584e572a/ssis-2012-package-executing-from-agent-job-but-throwing-error-from-catalog?forum=sqlintegrationservices

It appears from the above thread that this may not be solveable without MS's intervention. But...

Can you post the exact text of the error message when calling it from the system catalog?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

psingla Hall of Fame Points: 3840 More actions · Answer 5

Brandie Tarvin (8/14/2015)
psingla (8/13/2015)
following is the link of the discussion that I had with Arthur on MSDN forum
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/aeae8732-964c-4d9a-9255-b2c2584e572a/ssis-2012-package-executing-from-agent-job-but-throwing-error-from-catalog?forum=sqlintegrationservices
It appears from the above thread that this may not be solveable without MS's intervention. But...
Can you post the exact text of the error message when calling it from the system catalog?

Thanks Brandie for looking into this.Following is the exact problem that others are also facing.Perhaps I should open a ticket with MS.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/774b0e3e-3836-47e8-9feb-5b8f2c3b4b47/cannot-execute-package-from-remote-integration-services-catalog-involving-double-hop?forum=sqlintegrationservices

Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/

Brandie Tarvin SSC Guru Points: 173053 More actions · Answer 6

psingla (8/14/2015)

Brandie Tarvin (8/14/2015)
psingla (8/13/2015)
following is the link of the discussion that I had with Arthur on MSDN forum
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/aeae8732-964c-4d9a-9255-b2c2584e572a/ssis-2012-package-executing-from-agent-job-but-throwing-error-from-catalog?forum=sqlintegrationservices
It appears from the above thread that this may not be solveable without MS's intervention. But...
Can you post the exact text of the error message when calling it from the system catalog?

Thanks Brandie for looking into this.Following is the exact problem that others are also facing.Perhaps I should open a ticket with MS.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/774b0e3e-3836-47e8-9feb-5b8f2c3b4b47/cannot-execute-package-from-remote-integration-services-catalog-involving-double-hop?forum=sqlintegrationservices%5B/quote%5D

Sorry, but I don't have time to go hunting all over the internet. If you can post your error here instead of redirecting me to other places, I will try to help.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.