DTS package using ODBC fails when scheduled as a job

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Brian Beck" <Brian Beck@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Mon, 18 Jul 2005 15:35:01 -0700

I have a simple DTS package that downloads one table from an ODBC source
(CA/Datacom database). I can run the package with no problems. When I
schedule the package as a job it fails. The owner of the package and job is
the same as the SQLServerAgent. I can run and schedule packages with this
account that copy data locally with no errors, so I think it is a rights
issue with the account I am using ? If that is the case, then what rights do
I need to give this account to run a job that accesses an ODBC source?

Thanks,
Brian.
.

Follow-Ups:
- Re: DTS package using ODBC fails when scheduled as a job
  - From: Allan Mitchell

Prev by Date: DTS Datapump Column Order Unstable
Next by Date: Relative path for INI files
Previous by thread: DTS Datapump Column Order Unstable
Next by thread: Re: DTS package using ODBC fails when scheduled as a job
Index(es):
- Date
- Thread

Relevant Pages

SSIS Scheduling Failure - AcquireConnection Error
... package into SSIS services in Management Studio and ran the job manually. ... I got the dreaded 'AcquireConnection' error when I tried to schedule ... while logged onto the SQL Server 2005 database server itself. ... the 'SQL Agent Service Account'. ...
(microsoft.public.sqlserver.dts)
Re: Scheduling a simple local package wont stick
... Well my domain account is the owner, and it is member of the local ... Where do I find out if this Sql server service account has the necessary ... - When you run the DTS package yourself, it runs with your credentials, ... DTS packages do not retain a schedule. ...
(microsoft.public.sqlserver.dts)
Re: Task Scheduler question
... The task was set by a package, so there is no way that we can have the ... I have set the user account as 'Local System Account' by providing ... I read some doc and learned that I can schedule the task ... Is that done via setting parameters (in my ...
(microsoft.public.windows.group_policy)
Re: Task Scheduler question
... to 'full control' for everyone. ... The task was set by a package, so there is no way that we can have the ... I have set the user account as 'Local System Account' by providing ... I read some doc and learned that I can schedule the task ...
(microsoft.public.windows.group_policy)
Re: Task Scheduler question
... to 'full control' for everyone. ... The task was set by a package, so there is no way that we can have ... I have set the user account as 'Local System Account' by providing ... I read some doc and learned that I can schedule the task ...
(microsoft.public.windows.group_policy)