Hi All,

I ran into a problem invoking a DTS package from a different machine. I
wonder if anyone can enlighten me on what might cause the problem.

First of all, we have this weird arrangement that we created a DTS
package in sql 2000 and deployed it on 2000 server. However, we want to
invoke the package from another machine with only sql 7 on it. If I run
dtsrun on the 2000 box locally, it works beautifully. However, if I
invoke it from the sql 7 box, I got the following error:

DTSRun: Loading...

Error: -2147221005 (800401F3); Provider Error: 0 (0)
Error string: Invalid class string

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts.hlp
Help context: 713

My first question is if I can invoke the DTS on sql 2000 using
dtsrun.txt in sql7? I copied the sql 2000 version of dtsrun.exe to the
sql 7 box and I still got the same error. Then I wonder if this is
something to do with server security setup or something.

Any hint is highly appreciated

In message <1123881975.628278.208500 (AT) z14g2000cwz (DOT) googlegroups.com>,
bluemug <jianyangtai (AT) gmail (DOT) com> writes
You ideally need the SQL 2000 DTS DLLs on the machine that executes the
2000 built package. Remember that the package will be executed on the
machine from which you call DTSRUN, so it also needs the new tasks and
other objects available.

Upgrade the 2000 machine to 7.0, or execute the package on a 2000
machine. Put 2000 components on a 7.0 machine will cause licensing
issues.

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

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