Showing posts with label tools. Show all posts
Showing posts with label tools. Show all posts

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)

Interface for SQL Server database

Comments and ideas for software tools (ActiveX components)
to make a user interface for database.Do a google search

Madhivanan

Petteri wrote:
> Comments and ideas for software tools (ActiveX components)
> to make a user interface for database.|||Like this ;-)

http://www.google.fi/search?hl=fi&q...ogle-haku&meta=

Thank You, it helps

"Madhivanan" <madhivanan2001@.gmail.com> kirjoitti
viestiss:1149240372.946923.100540@.i39g2000cwa.goo glegroups.com...
> Do a google search
> Madhivanan
> Petteri wrote:
>> Comments and ideas for software tools (ActiveX components)
>> to make a user interface for database.|||Petteri (peter.rinne@.elperi.fi) writes:
> Comments and ideas for software tools (ActiveX components)
> to make a user interface for database.

Not really sure what the question is about, but if you work with ActiveX,
the obvious choice of client API is ADO.

But why ActiveX in this day and age? Why not .Net? Then you can use
ADO .Net, which despite the name is radically different from ADO -
and a whole lot better.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspxsql