Re: problem scheduling DTS package

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

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 10/28/04 

Date: Thu, 28 Oct 2004 19:51:21 +0100

Remember DTS is client side so you may be seeing this

Service Pack and Version Compatibility Problems
(http://www.sqldts.com/default.aspx?223) 

-- 
-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know
"dbacarbo" <dbacarbo@discussions.microsoft.com> wrote in message 
news:756050AC-71D2-4CC1-AFE4-DDBBEE9804EB@microsoft.com...
>I am having a problem scheduling a DTS package.  I can successfully execute
> the package from within Enterprise Manager or using the DTSrunui utility.
>
> I have tried right clicking on the package in Enterprise Manger to 
> schedule
> the job.  I have used the DTSrunui utility to schedule the job.  And I 
> have
> created a job "from scratch."  But I get the same error each time:
>
> Executed as user: SQLPROD1\SYSTEM. The process could not
> be created for step 1 of job 0xCD04C5DB50590C45A16E654D8D068B35 (reason: 
> The
> system cannot find the file specified).  The step failed.
>
> My DTSRUN statement looks something like this:
>
> DTSRun /Sservername/Uusername/Ppassword/Nnameofpackage
>
> I have used the encrypted DTSRUN statement that is generated when you 
> right
> click on the package and select Schedule Job option.  I have also used the
> DTSrunui utility to generate the DTSRUN statement.  But I still get the 
> same
> error.
>
> The package consists of dropping a table, recreating the table, and 
> loading
> data into the table from a flat file.  The flat file is on the SQL server 
> and
> DOES load when I execute the DTS manually.
>
> Any help that could be offered would be most appreciated.
>
> Thank you,
> Adria

Relevant Pages

  • Re: Scheduling Problem - Duplicate Attachments
    ... So how is the package requesting the Excel File? ... Allan Mitchell MCSE,MCDBA, www.SQLDTS.com - The site for all your DTS needs. ... > DTSRun: Executing... ...
    (microsoft.public.sqlserver.dts)
  • Not all steps in DTS package execute
    ... When run through DTS Designer, all steps execute except the last one (Step ... DTSRun OnFinish: DTSStep_DTSActiveScriptTask_2 ... Microsoft Data Transformation Services Package ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS job error
    ... the DTS schedule package functionality - you right click on ... the package on select Schedule Package. ... DTSRUN /~Zxxxxxxxxxxxx. ...
    (microsoft.public.sqlserver.server)
  • Scheduling DTS package using a stored procedure problem
    ... The DTS package runs fine through Enterprise manager successfully. ... DTSRun: Executing... ... Help file: sqldts80.hlp ...
    (microsoft.public.sqlserver)
  • Scheduling DTS Package using a stored procedure problem
    ... The DTS package runs fine through Enterprise manager successfully. ... DTSRun: Executing... ... Help file: sqldts80.hlp ...
    (comp.databases.ms-sqlserver)