Post reply

Delete SSIS package from the server

  • November 18, 2009 at 9:41 am

    #135256

    Hi All

    I have a few SSIS packages on a SQL server. i have admin access on the server.I am able to save packages on the server from Business intelligence studio.

    However when i try to connect to the Integration services from Management Studio, i get RPC server unavailable error ( which i assume is a firewall issue)

    i would like to know if there is a way to delete the SSIS packages on the server without connecting to Integration Services.

    Appreciate your help. thanks in advance

  • November 19, 2009 at 11:13 am

    #1081743

    anyone?

  • November 20, 2009 at 12:51 am

    #1082005

    Hi

    If you have problem connecting to the remote server, try this link

    http://msdn.microsoft.com/en-us/library/aa337083.aspx

    Regards

  • November 20, 2009 at 1:08 am

    #1082007

    Rene

    thanks for the reply.

    However, i do not have access to Administrative tools on the server.

    I connect from a client system to the SQL server that is install on an external server. I only have sysadmin access to the SQL server

  • November 20, 2009 at 1:21 am

    #1082010

    Hi

    Do you like to connect from your local SSMS to the SSIS server?

    If yes then follow the link I told you before.

    Regards

  • November 20, 2009 at 7:13 am

    #1082199

    Hi,

    you may use the procedure msdb.dbo.sp_ssis_deletepackage

    or you can directly delete from msdb.dbo.sysssispackages table.

  • November 20, 2009 at 12:42 pm

    #1082438

    thanks both

    will check and get back

  • November 20, 2009 at 3:28 pm

    #1082534

    braghuram

    thanks. i was able to delete the packages from the msdb.dbo.sysssispackages tables.

    rene

    As i have said, i do not have access to admin tools on the sql server or on my client system, i could not test. would try that on a system where i have the necessary rights. thanks for your time

Viewing 8 posts - 1 through 7 (of 7 total)

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