DTS Transformations - Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

DTS Transformations - Error

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-09-17 : 08:26:20

Michael writes "Hi,

I have created a Windows Service that is able to Start a DTS Package on a SQL Server. The Windows Service runs on a normal Workstation as a Domain User having Administrator Rights on the Workstation and on the SQL Server.

When executing a DTS Package, which i created for testing issues, in the Enterprise Manager it completes successfully. If it is started by the Service some tasks execute, but the Data Bump Tasks always fail with the message:

The Data Pump Task requires Transformations to be specified.

Could you please help?

This is the content of the Packages Log File:

#################################################################
The execution of the following DTS Package succeeded:

Package Name: TEST
Package Description:
Package ID: {E1997C9B-8F87-4D69-8416-D7F08C170C2E}
Package Version: {91E7CCAF-DAF9-4F0B-932D-38DE994C920B}
Package Execution Lineage: {3C4E5058-59C6-4B64-BE36-86BDD40AA21B}
Executed On: <-- the workstation with the service running
Executed By: <-- the User having the Admin Privileges
Execution Started: 29.07.2004 08:51:22
Execution Completed: 29.07.2004 08:51:22
Total Execution Time: 0,07 seconds

Package Steps execution information:

Step 'DTSStep_DTSDataPumpTask_1' 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:1100

Step Execution Started: 29.07.2004 08:51:22
Step Execution Completed: 29.07.2004 08:51:22
Total Step Execution Time: 0 seconds
Progress count in Step: 0

Step 'DTSStep_DTSCreateProcessTask_1' succeeded
Step Execution Started: 29.07.2004 08:51:22
Step Execution Completed: 29.07.2004 08:51:22
Total Step Execution Time: 0,05 seconds
Progress count in Step: 0
#################################################################"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources