I saved my dts package to another server and when I
execute the package from the new server it returns:

The specified DTS Package ('Name = 'pkgConvertFlatFile';
ID.VersionID = {[not specified]}.{[not specified]}') does
not exist.

How do I correct?

I'm executing it from ASP. I got it to work on my test
server, but when I transferred everything over to the
live server I received that error message. I have no
idea if it is related to the Execute Package Task.

Jeff

In article <059701c36698$9196d7f0$a301280a (AT) phx (DOT) gbl>, Jeff Borden
<jeff_borden (AT) hotmail (DOT) com> writes
In your ASP code are you specifying the package error version GUID on
the LoadFromXX method? Try just using the package name, and leave the
GUID and VersionGUID empty.


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

Have you tried omitting the ""

oPkg.LoadFromSQLServer sServer, sUID, sPWD, iSecurity , sPkgPWD,,, sPkgName




--

----------------------------
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



"Jeff Borden" <jeff_borden (AT) hotmail (DOT) com> wrote