I am working with a DTS package and within Disconnected Edit it shows more
tasks than what I actually have in the package. Tasks are showing up in
disconnected edit that do not exist in the design sheet. Is there any way to
delete these?

Thanks

Save As VB, and remove ghost objects from code Then run the VB to recreate
the package, and save back to SQL server.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Andy" <Andy (AT) discussions (DOT) microsoft.com> wrote

Dumb question, but where do you run the vb script from to recreate the package?

Thanks

"Darren Green" wrote:

It is VB 6, not VBScript. Save As VB gives you a module. You will need to
open this in VB, which will give you a project. Add the DTS Package Object
Library reference, verify the code, then compile and run within the VB IDE.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Andy" <Andy (AT) discussions (DOT) microsoft.com> wrote