Error running DTS package on a schedule (only!)

I created a DTS package & CAN run it (successfully) from Enterprise Manager
and from a command prompt.

When I try to schedule a job for this DTS package under SQL Server Agent
Jobs it gets the following error:

ATTRIBUTE_TYPES to [ThankYouAcknowledgements].[dbo].[ATTRIBUTE_TYPES] Step
DTSRun OnError: Copy Data from ATTRIBUTE_TYPES to
[ThankYouAcknowledgements].[dbo].[ATTRIBUTE_TYPES] Step, Error =
-2147467259 (80004005) Error string: [Sybase][ODBC Driver]Unable to
connect to database server: specified database not found Error source:
Microsoft OLE DB Provider for ODBC Drivers Help file: Help
context: 0 Error Detail Records: Error: -2147467259 (80004005);
Provider Error: 83 (53) Error string: [Sybase][ODBC Driver]Unable to
conn. The step failed.

Why does this package get an error ONLY when it's a scheduled job?

Thanks in advance.
--
Tyler
.

Relevant Pages

  • Scheduled DTS Package
    ... I have a DTS package that is schedule to run daily. ... created and made the connection to the SQLServer using Windows ... changes, even though the scheduled DTS is using Windows authentication, the ...
    (microsoft.public.sqlserver.dts)
  • Re: Running DTS from a command prompt
    ... DTSRUN and then schedule with sql agent to do xp_cmdshell command. ... also create a ssis package that has a Execute DTS Package and the schedule ... I am attempting to run a DTS package from a command prompt using the ...
    (microsoft.public.sqlserver.datamining)
  • Re: DTS Package wont run as Job
    ... account, it depends on what you are doing in step 1 but it ... looks like it could possibly be a matter of the SQL Server ... I have a DTS package that has the following 3 steps as VB Script Modules: ... >However if I schedule it as a job I get the following errors: ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Package scheduled to run as job never runs
    ... >I have a dts package that when scheduled via Enterprise ... Double check that the job schedule is enabled. ... Darren Green (SQL Server MVP) ... global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Re: How To Setup a Batch Job To Run Daily
    ... If you use SQL Server Agent then there is a job step that effectively gets the cmdline for you ) ... DTSRun is a command line interface to call a DTS Package. ... use DTS package to schedule the job that I setup in DTSRun. ... You simply call the batch file. ...
    (microsoft.public.sqlserver.dts)