Clever Geek Handbook

How do I reference SSIS on a build machine without installing the SQL Server 2008 client tools?

I need to create SSIS packages on a build machine and don't want the overhead of installing SQL Server Management Studio on that machine. The SQL Server 2008 SDK would be perfect, but I couldn't find where to download it.

Required DLLs (for example):

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

I could try to copy them to the build machine separately, but I would rather just use the SDK if possible.

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

0


source to share


3 answers


Perhaps you could manually copy things and register them with the GAC, but the client tools are hardly huge and not time consuming, so I don't understand why they are significant overhead?



As far as I know, there is no other way to get these assemblies.

0


source


I don't know about SQL 2008, but the SQL Server packages for SQL Server are developed in Visual Studio.

Edited: When you run the installation for client tools, it allows stuff to be added to VS.NET, the "Client Tools" as such can be undone (end editing)



SSMS can be used to manage and administer them.

What other editor would you like to use ...?

0


source


I think it is trying to execute SSIS packages as part of an automated continuous build process. The way I did it was to have SQL Server Express and SSIS on the build machine, use the BIDS helper to script the cmd command line file to deploy packages, and use NANT to use that script. Hope this helped.

0


source






More articles:


All Articles