Delete SSIS package from the server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Delete SSIS package from the server

Delete SSIS package from the server

Rate Topic

Display Mode

Topic Options

Author

Message

hussain27syed

Posted Wednesday, November 18, 2009 9:41 AM

SSC 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

hussain27syed

Posted Thursday, November 19, 2009 11:13 AM

SSC Rookie

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

anyone?

Post #821833

rene-500237

Posted Friday, November 20, 2009 12:51 AM

SSCrazy

Group: General Forum Members
Last Login: Friday, May 17, 2013 4:26 AM
Points: 2,293, Visits: 1,099

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

hussain27syed

Posted Friday, November 20, 2009 1:08 AM

SSC 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

rene-500237

Posted Friday, November 20, 2009 1:21 AM

SSCrazy

Group: General Forum Members
Last Login: Friday, May 17, 2013 4:26 AM
Points: 2,293, Visits: 1,099

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

braghuram

Posted Friday, November 20, 2009 7:13 AM

SSC-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

hussain27syed

Posted Friday, November 20, 2009 12:42 PM

SSC 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

hussain27syed

Posted Friday, November 20, 2009 3:28 PM

SSC 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 »

Permissions