This is probably a dead easy question. I have deployed 3 SSIS packages to sql server, but now i cannot find any option anywhere to delete them How do i delete SSIS packages from the SQL Server instance they were deployed to
Ok my main problem was that i could not find them , but i realised i have to register it as a integration services server, then connect to it , correct
Ok first question i have sql2000 and sql2005 instances running on my machine, when i register the SSIS server , it will not accept seanlo\sqlserver2005 , it says it does not support multiple instances, so therefore i have to register it as just seanlo, problem is that is my sql 2000 instance So i am not sure how to register the SSIS server as it will not accept the name of my 2005 instance
If i try simply enter SQLSERVER2005 as the instance, it get the following error: Connect to SSIS Service on "SQLSERVER2005" failed, The RPC server is unavailable
Now i am not sure how SSIS servcies work in SQL Server 2005, i have chcked that the SQL Server2005 and SSIS services are started and running on my machine
deleting sql server 2005 deployed packages?
David Homer
Oi, I'm claiming all the credit for this one :)
SUpton
Kirk has posted on this: http://www.sqljunkies.com/WebLog/knight_reign/archive/2005/06/08/15765.aspx
It tells you all you need to know.
-Jamie
Kasracer
micca
Ok my main problem was that i could not find them , but i realised i have to register it as a integration services server, then connect to it , correct
Ok first question i have sql2000 and sql2005 instances running on my machine, when i register the SSIS server , it will not accept seanlo\sqlserver2005 , it says it does not support multiple instances, so therefore i have to register it as just seanlo, problem is that is my sql 2000 instance So i am not sure how to register the SSIS server as it will not accept the name of my 2005 instance
If i try simply enter SQLSERVER2005 as the instance, it get the following error:
Connect to SSIS Service on "SQLSERVER2005" failed, The RPC server is unavailable
Now i am not sure how SSIS servcies work in SQL Server 2005, i have chcked that the SQL Server2005 and SSIS services are started and running on my machine
Thanx again for the help!
n_sateesh
Carpe Noctem