SSIS package running fine from visual studio, but not from Sceduler ?

Hi!

When i run my OLAP package (SSIS)  from visual studio. It runs just fine.

But setup this package to run from Microsoft server manager..
as a sceduler job it fails....

What is wrong ?

Olso try to run the pack from dos promt, using -> dtexec.exe
And here it works fine to

Please help
LVL 2
team2005Asked:
Who is Participating?
 
liijaCommented:
My first comment applies.
Most likely you are trying to run SSIS package with Agent Service user account - which might be local system account. Agent Service user account doesn't have access to the OLAP cube  you are trying to process.
There are several different ways to get around this, here are a couple of them:

- Implement proxy account:
http://www.buildingmeaning.com/?p=89

- Check the link in my first post. In agent job there is a tab 'Data Source'. There you are able to manage the connections within the specific package inside the scheduled job.

- Implement package configurations.
http://www.simple-talk.com/sql/ssis/xml-configuration-files-in-sql-server-integration-services/

- Hardcode the user credentials into the SSIS package. Now you are probably using trusted connection. When you run this scheduled it won't work. Add a user and password inside your SSIS package. Set on the package security option 'EncryptSensitiveWithPassword'. This encrypts the connection credentials. Use naturally the same password in SQL Server Agent Job.
0
 
liijaCommented:
How have you taken care of user authentication in the data sources?
If you haven't defined anything inside the agent job - or are not using e.g. package configuration files, the agent service credentials are used. Probably it doesn't have rights to the data sources.

Check out this:
http://www.mssqltips.com/sqlservertip/1180/sql-server-integration-services-package-scheduling-with-sql-agent/
0
 
Eugene ZCommented:
<What is wrong ?>

What is the error?

make sure you do not use C:\yourPCfolder
use instead UNC path:

\\servername\SharedFolder_With_NTFSSqlserverLoginPermissions_That_youSetSqlAgentJob
0
 
team2005Author Commented:
Hi!

Get tis errors:

Error: Failed to acquire connection "Olap". Connection may not be configured correctly or you may not have the right permissions on this connection.
0
 
team2005Author Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.