How can I install SSIS on client side?

Hi,

We just moved from SQL 2000 to SQL 2005 Ent. To use SSIS service, I need install this package on client side. But when I install the 2005 on my PC(Win XP Prof), I did not find any place I can include it. Anyone has similar experience or know how to do it?

Thanks in advance,

Jie

Hi Jwei,

Take That CD 1 and choose Workstation components, Books Online and development tools.

That'll install the following components:

.BOL

.Native client

.BIDS

.SQLXML4

.MSXML6

.OWCL11 (Office Windows Components)

.SQL Server Backward-Compatibility Files

HTH

|||

Stop! Make sure you understand the license changes for SSIS compared to DTS. Put simply you can no longer redistribute SSIS as a client component, like you could with DTS. SSIS is a server component, so machines must be licensed with server license, not just a CAL.

|||you're right...|||

Thanks a lot for taking time to respond to my post.

I had problem with the license change, just could not believe it.

"no longer redistribute SSIS as a client component, like you could with DTS" is a key to me.

|||

Then, how can I install only SSIS Client on my work station?

Please help

Thanks

|||Run setup. Choose the Integration Services and Workstation components options.|||

TDRao wrote:

Then, how can I install only SSIS Client on my work station?

SSIS client components are installed when you install Workstation components - that gives you BIDS (with ability to design and debug SSIS projects and packages) and SSMS (with ability to connect to SSIS service and monitor package execution).

To run packages in production you need SSIS server components, which are installed when you install Integration Services. That requires server license.

|||

Thanks a lot for the solution