Re: Connecting to SSIS from Management Studio
- From: Derek <Derek@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 29 Jul 2009 00:34:01 -0700
It would be good if you can find out how to make VS 2008 and SQL Client 2008
co-exist. We have been trying to use the SQL 2005 client until recently but
SSIS does not work at all when you have VS 2008 on the PC, the SSIS component
dosn't get installed.
The only work around we have at the moment is to Remote Desktop the server
which is less than ideal.
--
Derek
"Sean McCown" wrote:
Sorry I don't have a definitive answer, but sometimes katmai and yukon tools.
don't play well together. Perhaps this is one of those times.
If you like I can test it for you though and see if I can get it to work in
my environment.
"Derek" <Derek@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8974AEFF-1A8C-423B-9E35-356539A7E74B@xxxxxxxxxxxxxxxx
I have SQL Server 2008 client and Visual Studio 2008 installed on a PC I
am
able to connect to all of the SQL 2000 and SQL 2005 servers using the
database engine connection but when I try to connect to a SQL 2005 server
using the Integration Sercices connection I get the following error:
Cannot connect to GY-SQL-01
Additional information
Failed to retrieve data for this request.
(Microsoft.sqlserver.Management.Sdk.Sfc)
Connect to SSIS Service on machine "GY-SQL-01" failed:
Class not registered
Does anyone know How I can get this to work. SSIS works for this server
from
a PC with SQL 2005 client.
--
Derek
- References:
- Connecting to SSIS from Management Studio
- From: Derek
- Re: Connecting to SSIS from Management Studio
- From: Sean McCown
- Connecting to SSIS from Management Studio
- Prev by Date: how to move Excel formula to SQL server ?
- Next by Date: Why doesn't this work? ASP -> SQL Server 2008 Select Distinct
- Previous by thread: Re: Connecting to SSIS from Management Studio
- Next by thread: Application cannot connect to SQL
- Index(es):
Relevant Pages
|
