Getting a SSIS Package to run under SQL Server Agent Scheduled Jobs

Tech-Archive recommends: Fix windows errors by optimizing your registry

I created a SSIS Package 2 ways. Both ways were unsuccessful.
1st. I used the Import/Export wizard to import a MS Access Database into
SQL 2005. I saved as a SSIS Package. When I ran it manually, it ran
successfully. So, I scheduled the job with the run as SQL Server Agent
Service Account, and owner as my domain account. But, when I execute the
job from the SQL Server agent, it fails.

2nd. I built a dts package in Business Intelligence Development Studio,
connecting to an MS Access database and transfering data to a SQL 2005
database. This ran successfully. But, when I built it, deployed to the
server and created a job, again running under SQL Server Agent Service
with creator or owner as my self, the job still failed.

I tried saving to file system, and SSIS Store. I tried using a proxy
account and still doesn't work.

I need to have some steps to follow. Can anyone help me with this. If
you can email me at dillig@xxxxxxxxxxx

Donovan


*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: Browsing for Publication error message
    ... what is going on with the description you gave previously but I would guess that the subscriber SQL Server Agent service account was somehow added to the publication access list of the publication on the DMZ. ... select from the MSpublication_access table in the distribution database and see if the account for your Subscriber's SQL Server Agent service account shows up. ...
    (microsoft.public.sqlserver.replication)
  • Re: Problems with SQL Srv. Agent and Proxy Account
    ... Windows Account. ... SQL Server Agent, try adding this account to the local ... >Password verification of the 'SQLAgentCmdExec' proxy ...
    (microsoft.public.sqlserver.security)
  • Re: Re-installing SP4
    ... > I will try unregistering the components with the service account but what ... >> guessing that you want a cleaner approach so you are wondering if an SP4 ... >> 1) SP4 setup could not retrieve information for the SQL Server Agent ... >> privilege to enumerate the Agent service account information. ...
    (microsoft.public.sqlserver.replication)
  • Re: Distributor SQLSERVERAgent Account
    ... your subscriber's sql server agent should be running ... under the same account as the publisher's SQL Server agent, ... that is part of the local admin group on the publisher. ... If this is not possible the SQL Server agent account on the subscriber ...
    (microsoft.public.sqlserver.replication)
  • Re: Problems with SQL Srv. Agent and Proxy Account
    ... You need to go to the General Tab of the SQL Server Agent ... >I have tried with both the sa account and with Use Windows ...
    (microsoft.public.sqlserver.security)