Does anyone knows what is needed in each PC for that?

Hi everyone,

I’m pursuing a fast deployment for SSIS. I mean, we’ve got ten ASP/VB6 developers which often doing some DTS stuff by mean, of course, Enterprise Manager.

Now, they’d have to handle the same but with SSIS. I don’t have very clear whether only is necessary install them SSIS component or it’d requires something else. Framework 2.0 too?

If they are building packages then they will need BIDS installed. If they want to run them on their client machines from outside BIDS then they will need SSIS installed (which is a different install option on the CD).

Framework 2.0 is required but that will be installed off the SQL Server CD automatically if it is needed (I think).

Does that answer the question?

-Jamie

|||

Hi Enric,

Please browse through "Installing SQL Server Integration Services by Using Setup " @. http://msdn2.microsoft.com/en-us/library/ms143510.aspx were they have detailed on the different components of SQL Server Install and their applications. and http://msdn2.microsoft.com/en-us/library/ms143731.aspx (has got information on "Installing Integration Services Side-By-Side with SQL Server 20000 Data Transformation Services)

.NET Framework 2.0 is a must requirement.

Thanks,
Loonysan

|||

Jamie,

Yeah, that asnwer partially my question because I don't know if is needed a license per place or not.

Loonysan,

Thanks for that link.

|||

Do you have an MSDN subscription? I think that covers you to have Developer Edition on each machine.

-Jamie

|||

yes, we have. Thanks.

something else. When people talks about 'Client Tools' for Sql Server 2005 are they talking about BIDS environment and SSIS component generally speaking?

|||

Well i guess it depends who you're asking. When I talk about client tools I mean SSMS and BIDS (which includes the SSIS Designer). I do not mean SSIS. There is a distinction here.

-Jamie

|||OK