Post reply

Delete a Package

  • October 25, 2005 at 12:14 pm

    #188141

    Simple question.

    I was able to save a package to my SQL Server using the 'Save Copy of ....' command in the GUI.

    How do I delete a package from my SQL Server?

  • October 25, 2005 at 1:17 pm

    #599925

    In EM, right-click the package and select Delete. If the option is not available, you do not have rights to delete the package.

  • October 25, 2005 at 1:20 pm

    #599926

    In SQL 2005?

  • October 25, 2005 at 1:43 pm

    #599932

    Well, ummm... it helps if I check which forum I am posting to.   Sorry, I didn't realize this was for SQL 2005. Not sure how you would do in the new version.

    I find it interesting that there is no documentation about this on Microsoft's site.

  • October 25, 2005 at 2:07 pm

    #599943

    I couldn't find anything in the documentation, except for the DTUTIL command line utility, but I can't get that to work!

  • October 25, 2005 at 11:52 pm

    #600013

    In Management Studio, right click and select delete or just select it and hit delete.

    K

  • October 26, 2005 at 7:05 am

    #600114

    Where? I don't see that option, except for legacy DTS packages, but this isn't a legacy package.

  • October 26, 2005 at 9:37 am

    #600257

    Open a connection to the Integration Services server in the object explorer.

    K

  • October 26, 2005 at 10:21 am

    #600290

    Amazing....thanks

  • January 11, 2006 at 1:36 pm

    #614183

    I'm stumped here.  I'm not actually trying to delete a package, just connect to integration services from the BI studio.  I have four installations of BI studio on different computers, one my workstation and three on other computers.  For some reason on my workstation I can see the "connect to server" and "connect to database" options, but on all three other computers I only have the "connect to database" option.  Strangely, the "connect to server" option isn't even grayed out, it's entirely missing/hidden.  Any idea how to get it back?


    Shane

  • January 16, 2006 at 10:26 am

    #614955

    BI studio shouldn't have these options, it's Management Studio, yes?

    Is Integrations Services installed on all machines?

    I've never seen a connect to server option in Management Studio.

    In BIDS, the connect to server option is for the WMI connectivity which is only available if you have Visual Studio installed on the machine as well.

    To see the packages and connect to the IS server, you need to be in Management Studio on the Object Explorer window.

Viewing 11 posts - 1 through 10 (of 10 total)

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