SSIS installation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ChiWhiteSox - 22 Feb 2006 18:27 GMT

I just successfully installed sql 2005 on my machine with all the optional
items checked ( Integration Service,Analysis Services etc..)

But after I installed Microsoft SQL Server 2000 DTS Designer Components from
microsoft, I couldnt find SSIS on SQL Mgmt Studio.

Isnt it suppose to be under managment on SMS ?

thanks!

Reply to this Message

Sue Hoegemeier - 23 Feb 2006 04:37 GMT

Did you try -
File - > Connect
In the Connect to Server dialog, select Integration Services
from the server type drop down. Put in server name,
authentication info and then hit connect.
If you are looking for the designer, you need to use the
Business Intelligence Development Studio that comes with SQL
Server 2005. From there you can start or open an Integration
Services project.

-Sue

>I just successfully installed sql 2005 on my machine with all the optional
>items checked ( Integration Service,Analysis Services etc..)
[quoted text clipped - 5 lines]
>
>thanks!

Reply to this Message

ChiWhiteSox - 23 Feb 2006 15:51 GMT

thanks so much Sue!!

God Bless

> Did you try -
> File - > Connect
[quoted text clipped - 17 lines]
> >
> >thanks!

Reply to this Message

ChiWhiteSox - 23 Feb 2006 15:56 GMT

oh, i tried changing the server type and then logging in, and then i got an
Error Message:

Failed to Retrieve
Connect to SSIS Service on machine "64.33.33.111,8802" failed:
The RPC server is unavailable

any Ideas?

> Did you try -
> File - > Connect
[quoted text clipped - 17 lines]
> >
> >thanks!

Reply to this Message

HomeBrew - 23 Mar 2006 19:45 GMT

I have the same problem. Did you resolve it ?? I've seen a few other
posts with the same problem, but no solutions. Hey, Microsoft .... what's
the deal !?!?!?

> oh, i tried changing the server type and then logging in, and then i got an
> Error Message:
[quoted text clipped - 26 lines]
> > >
> > >thanks!

Reply to this Message

Mohan P - 26 Jan 2007 19:09 GMT

Check this. You have to set COM Security on the remote machine.

http://mohansmindstorms.spaces.live.com/Blog/cns!69AE1BEA50F1D0E7!213.en
try

Reply to this Message