Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Delete SSIS package from the server Expand / Collapse
Author
Message
Posted Wednesday, November 18, 2009 9:41 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, August 13, 2011 3:28 AM
Points: 41, Visits: 112
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
Post #820955
Posted Thursday, November 19, 2009 11:13 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, August 13, 2011 3:28 AM
Points: 41, Visits: 112
anyone?
Post #821833
Posted Friday, November 20, 2009 12:51 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, December 24, 2014 2:46 AM
Points: 2,528, Visits: 1,150
Hi
If you have problem connecting to the remote server, try this link
http://msdn.microsoft.com/en-us/library/aa337083.aspx
Regards
Post #822136
Posted Friday, November 20, 2009 1:08 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, August 13, 2011 3:28 AM
Points: 41, Visits: 112
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
Post #822138
Posted Friday, November 20, 2009 1:21 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, December 24, 2014 2:46 AM
Points: 2,528, Visits: 1,150
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
Post #822141
Posted Friday, November 20, 2009 7:13 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 17, 2012 9:32 AM
Points: 184, Visits: 44
Hi,
you may use the procedure msdb.dbo.sp_ssis_deletepackage
or you can directly delete from msdb.dbo.sysssispackages table.
Post #822371
Posted Friday, November 20, 2009 12:42 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, August 13, 2011 3:28 AM
Points: 41, Visits: 112
thanks both

will check and get back
Post #822647
Posted Friday, November 20, 2009 3:28 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, August 13, 2011 3:28 AM
Points: 41, Visits: 112
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
Post #822757
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse