How do I reference SSIS on a build machine without installing SQL Server 2008 Client Tools?

Question

I need to build SSIS packages on a build machine, and do not want the overhead of installing SQL Server Management Studio on this machine. A SQL Server 2008 SDK would be ideal, but I could not find where to download it.

The dlls I require are (for example):

• Microsoft.SQLServer.ManagedDTS
• Microsoft.SqlServer.PipelineHost
• Microsoft.SqlServer.DTSPipelineWrap
• Microsoft.SQLServer.DTSRuntimeWrap

I could attempt to copy them to the build machine individually, but I would rather just use an SDK if possible.

Where can I get the SDK, or alternatively, what suggestions are there?

Answer 1

You could probably manually copy things about and register then in the GAC, but the client tools are hardly huge, and don't take long to install, so I don't see why they are much of an overhead?

As far as I know there's no other way to get those assemblies.

Answer 2

I can't comment for SQL 2008 but SQL 2005 SSIS packages are developed in Visual Studio.

Edited: When you run install for client tools, it's an option to add the stuff to VS.NET, "Client tools" as such can be deselected (end edit)

SSMS can be used to manage them and administer.

What other editor did you want to use...?

Answer 3

I think he is trying to accomplish SSIS packages as part of the automated continuous build process. The way i did it was to have an express edition of SQL Server and SSIS on the build machine, use BIDS helper to script the cmd line file for deploying the packages and use NANT to use this script. Hope this helped.