When loading a package from within an ActiveX script
using the following code:

'Connect to DTS Package
Set oPackage = CreateObject("DTS.Package2")
oPackage.LoadFromSQLServer
ServerName, "********", "******", 0, , , , "DW_Copy_Table"

I get the following error message:

Step Error Source: Microsoft Data Transformation Services
(DTS) Package
Step Error Description:Not implemented

Step Error code: 80074001
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:4500

This error only occurs when I execute the package. If I
execute the activex step by itself it works fine.

I am running SQLServer 2000 with Service Pack 3 on an XP
Pro Box conneected to a Windows 2003 server.

Can anyone please tell me what this message number
relates to.

Thanks in advance
Darren Morrow

What happens if you use the Package object not the Package2 object?

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Darren Morrow" <anonymous (AT) discussions (DOT) microsoft.com> wrote

we get the exactly the same error message...

the problem does not appear to be with the line itself as
the code executes fine when we execute just the step. it
is when we run the package that we get this error message -
which means that executing a step is different to
executing a package - but what?

weve just solved it

went to your web site and did a search on that error code
in the google groups...

apparently you need to go to each steps workflow
properties/options tab and ensure that "execute on main
package thread" is checked...

thats fine and makes sense - would be nice if the error
message actually said that rather than "not implemented" -
which is actually referring to the error number not being
implemented...

mark.