Friday, March 23, 2012

Intergation Services Templates for Visual Studio 2005

We are setting up developer machines with Visual Studio 2005 and SQL SERVER 2005 Client tools. My question is how do I get the templates for Integration Services into Visual Studio 2005 without installing BIDS?

You cannot do this. The Visual Studio IDE hosts packages, one of which is the SSIS designer for example. The only way to install that package is to install the Workstation components for SSIS from SQL Server Setup.

If you do not already have the VS IDE it is included as part of this setup. If you installed SQL first, then would you expect to be able to install the C# or VB package without running the full Visual Studio setup? The packages are slightly different, but the logic is the same.

There are also package templates, but I don't think that is what you mean (http://wiki.sqlis.com/default.aspx/SQLISWiki/PackageTemplates.html)

No comments:

Post a Comment