Hi,
I have a dts written by somebody and is running, but I
doubt it eveer worked. When I check the output file, it
says:

Step 'Create Table Step' succeeded
Step Execution Started: 11/4/2003 10:12:25 AM
Step Execution Completed: 11/4/2003 10:12:25 AM
Total Step Execution Time: 0 seconds
Progress count in Step: 0

Step 'Copy Data from Results Step' failed

Step Error Source: Microsoft Data Transformation Services
(DTS) Package
Step Error Descriptionata Source Object name or SQL
Statement is required to obtain a Rowset. (Microsoft OLE
DB Provider for SQL Server (80070057): The parameter is
incorrect.)
Step Error code: 8004040A
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:4700

Step Execution Started: 11/4/2003 10:12:25 AM
Step Execution Completed: 11/4/2003 10:12:25 AM
Total Step Execution Time: 0.016 seconds
Progress count in Step: 0

but in the DTS Designer, there is no "'Copy Data from
Results to Results Step'", where can I find it?

If you are on SQL Server 2000, use the Disconnected Edit to
check the step names. The designer shows the description for
names not the actual step name and the two can be different.

-Sue

On Tue, 4 Nov 2003 10:30:39 -0800, "Edward"
<anonymous (AT) discussions (DOT) microsoft.com> wrote:

Thanks, yes I found it under both Tasks ansd Steps, but
where can i find out thow the task was defined?

Thanks

I'm not sure what you mean. The individual task properties
are under Tasks in the disconnected edit and include what
the task does...e.g. the script for an ActiveX script task
is defined in the property ActiveXScript, data pump task has
the transformations, lookups, etc listed under it's node.

-Sue

On Tue, 4 Nov 2003 13:44:46 -0800,
<anonymous (AT) discussions (DOT) microsoft.com> wrote: