Hello Leslie,
Based on the error message you are expriencing, it seems like some of the
transformations have not been selected for that task and thus causing the
error.
To ensure you have selected the transformations:
1) Open the DTS package.
2) Double-click on the Data Transformation line for this particular
transformation
3) Click on the Transformation tab.
4) In the NAME drop-down, select the transformation
5) Repeat for all transformations.
6) Save, close, reopen, and test.
Further to this it may be related to the way scheduled jobs run - for
further information on this please read the below KB article:
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/default.aspx?scid=kb;en-us;269074
Regards,
Shashank Pawar
SQL Server Support Engineer, Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| Thread-Topic: dts schedule errors
| thread-index: AcTNpbKCRipiW3JuQtqaJ1IO4dGqXA==
| X-WBNR-Posting-Host: 69.15.33.194
| From: =?Utf-8?B?TGVzbGll?= <***@discussions.microsoft.com>
| Subject: dts schedule errors
| Date: Thu, 18 Nov 2004 11:35:02 -0800
| Lines: 15
| Message-ID: <B84EB5C5-0DED-4A62-8700-***@microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.dts
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.dts:53169
| X-Tomcat-NG: microsoft.public.sqlserver.dts
|
| I have some scheduled dts packages. They error out with this message
every
| time. I can run the package manually with no problem.
|
| Step 'Copy Data from AGENCY to [CMHC].[dbo].[agency] Step' failed
|
| Step Error Source: Microsoft Data Transformation Services (DTS) Package
| Step Error Description:The Data Pump Task requires Transformations to be
| specified.
| Step Error code: 80040408
| Step Error Help File:sqldts80.hlp
| Step Error Help Context ID:4700
|
| Any help would be appreciated.
| --
| Leslie
|