Wednesday, March 21, 2012

Package from Package Sore does not work as Job

Dear All,

I try to run a Package which is placed in the Package Store via a job - but this does not work.

Some things about the package:
- The package evokes some warnings, because I do not use all columns from the datasource
- Package runs in BI Studio - log is written
- Package runs if startet from the Package Store - log is written
- Package Execution stopps immediately if started via job - without writting in the log

As hint - needless to say :-) - that the log provider is configured in all three spaces...
Does anybody now, if I could use the configured log provider from the package directly in the jobs _without_ doing the settings?

Other jobs - without the warnings - are running and placing there step results in the log.

Thanks in advice!

Cheers
Markus

Some info that may help-

Scheduled Packages
(http://wiki.sqlis.com/default.aspx/SQLISWiki/ScheduledPackages.html)

|||

Darren,

sorry for this late reply - you are right!
The user did not have appropriate rights on the package store folder.

cheers,
markus

No comments:

Post a Comment