Hi,

I'm getting the following error on a win2k sp2 machine when I run my
DTS package

Step Error Source: Microsoft Data Transformation Services (DTS) Data
Pump
Step Error Description:The number of failing rows exceeds the maximum
specified. (Microsoft Data Transformation Services (DTS) Data Pump
(80020101): ActiveX Scripting Transform 'DTSTransformation__1'
encountered a Run Time Error during the execution of the script.)
Step Error code: 8004206A
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0

However when I run it on another box, win2k sp3, I get no errors at
all.

The execution fails always on the first row. I've removed a few rows
and massaged the data but neither of these work. The dts fails always
on the transformation which is from a flat file to a Sybase 11
datasource. The vbscript in the transformation parses ok and runs ok
on the win2k sp3 box.

Any help would be appreciated.

I've tracked the error message down to the following. I assign a
dictionary object to a Global Variable as part of an ActiveX script
step. As part of the transformation that's failing I assign the Global
Dictionary object to a local variable i.e. one just dim'd in the
transformation script. When I try and use the exists method on the
local dictionary object I get the error message below. I've included
some sample code from the Transformation. The vartype of myDc is 9 and
the TypeName is Object.

Dim myDc
Set myDc = DTSGlobalVariables("Dictionary").value

If myDc.Exists("SomeKey") Then
'Process row.....
Else
'Skip row
End If

Can someone shed some light?

danfromdublin (AT) yahoo (DOT) com (Dan) wrote in message news:<fc71ba4e.0408120750.1a46cbe7 (AT) posting (DOT) google.com>...

In message <fc71ba4e.0408121723.7b51285d (AT) posting (DOT) google.com>, Dan
<danfromdublin (AT) yahoo (DOT) com> writes
That looks like a scheduled package log output, so can you logon to the
box itself, using the same account as SQL Server Agent and run the
package manually to see if you can get a better error description from
within Enterprise Manager?

Try setting the ActiveX Script Task that creates the Dictionary object
and the DataPump task that uses it to both execute on the main thread.
(Right-click task, Workflow Properties, Options).


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Darren Green <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote

Darren,

This error was occuring only when the package was being executed
through vb. The vb code created a DTS package object which pointed to
the dts file and executed it. I just couldn figure out even through
enterprise management what the error was, I didn't get any further
information back. As the Dictionary object was created from values
returned from a recordset I just used the find method of the recordset
object to perform the same function. Not really a fix but a work
around.

Thanks,

Dan