Hi, Guru:

Is there any way to delete a DTS package, I mean, not from Enterprise
Manager? Did anyone try SQL-NS or have any other source code?

Scenario:

I have a VB coding which creates a DTS package and then saves it to SQL
Server, but somehow there is a existing old DTS, at this point, I will get
an error.

I hope,
-.Delete the existing one first
or
-.Update the existing one with the new one


Thanks in advance!

What about the

RemoveFromSQLServer method of the Package object



--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"SQLNewbie" <SQLNewbie (AT) hotmail (DOT) com> wrote

perfect answer.

Thank you very much!


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote