Post reply

Cannot delete ExecuteSQLTask

  • March 22, 2005 at 4:31 pm

    #60002

    DTSStep_DTSExecuteSQLTask_8

    is not showing in DTS Designer but it exists if I open Disconnect Edit.

    How can I get rid of it?

    I don't want to build this package from scratch again.

    Thanks,

    Robert

  • March 23, 2005 at 11:21 am

    #548560

    Try this... Open the Package up in Designer.. select everything... open up a new Package and paste them into the new package... now save it.

    That may save you some time in re-creating the package. 

    The other option is to open it up programatically and removing the step and saving it.  Not a very difficult task at all, just make sure that no other steps have it setup as a predecessor, and the task you want to remove has none either.

    Mike Gercevich

     

  • March 23, 2005 at 3:00 pm

    #548611

    Hi Mike,

    Thank you for your response.

    If I save my DTS as .BAS file I can locate that ghost Task

    and remove it from code but then how do I convetr it back to DTS?

    Nobody in our dep knows how to do it.

    Is there a way?

    Thanks,

    Robert

  • March 23, 2005 at 3:52 pm

    #548625

    There is a line in the VB code that executes the package. Just above that is a line that is commented out which saves the package back to SQL.

    Look up SaveToSQLServer in Books Online for the syntax.

     

    --------------------
    Colt 45 - the original point and click interface

  • March 23, 2005 at 5:22 pm

    #548635

    Thank you so much phillcart!

    That's a very good finding.

    Robert

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply