dts schedule errors

#1

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

#2

It would appear that the mappings between the SourceColumns and DestinationColumns properties are getting lost somewhere.

What SP revision are you using on the server itself?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com

"Leslie" <Leslie (AT) discussions (DOT) microsoft.com> wrote

Quote:

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

#3

SP3

"Allan Mitchell" wrote:

Quote:

It would appear that the mappings between the SourceColumns and DestinationColumns properties are getting lost somewhere.

What SP revision are you using on the server itself?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com

"Leslie" <Leslie (AT) discussions (DOT) microsoft.com> wrote

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

#4

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...b;en-us;269074

Regards,

Shashank Pawar
SQL Server Support Engineer, Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

Quote:

Thread-Topic: dts schedule errors
thread-index: AcTNpbKCRipiW3JuQtqaJ1IO4dGqXA==
X-WBNR-Posting-Host: 69.15.33.194
From: =?Utf-8?B?TGVzbGll?= <Leslie (AT) discussions (DOT) microsoft.com
Subject: dts schedule errors
Date: Thu, 18 Nov 2004 11:35:02 -0800
Lines: 15
Message-ID: <B84EB5C5-0DED-4A62-8700-C9BC8319F5DD (AT) microsoft (DOT) 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!TK2MSFT NGXA03.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

#5

| Step Error Source: Microsoft Data Transformation Services (DTS) Package

Quote:

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

Getting this error then followed Pawar's solution to add that transformation name from transformation tab.

From http://www.developmentnow.com/g/103_...ule-errors.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

dts schedule errors

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

dts schedule errors - 11-18-2004 , 02:35 PM

Re: dts schedule errors - 11-20-2004 , 02:27 AM

Re: dts schedule errors - 11-30-2004 , 02:51 PM

RE: dts schedule errors - 01-13-2005 , 05:21 PM

RE: dts schedule errors - 04-29-2010 , 10:51 AM