How to delete package from SQL Server 2005?

[katbear]

Hi,

version is SQL Server 2005

When I query "sysdtspackages90", I see that I have a package there that I want to remove.

What is the correct way to remove the package from SQL Server?

Thank you

 

[MDXer]

you should make no direct changes to any of the sys tables. To remove a SSIS package you open SSMS to the SSIS Server and delete the package there, using a simple Right Click and delete.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[katbear]

To remove a SSIS package you open SSMS to the SSIS Server and delete the package there, using a simple Right Click and delete.

Can you please explain how I open SSMS to SSIS in Management Studio?

Thanks

 

[ptheriault]

From object explorer click the connect button
In the drop down select Intergration Services. Make sure you have the correct SSIS server name and connect to the instance.


- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[katbear]

Yes, I found it

thanks