December 19, 2007 at 8:27 am
I have SQL Server 2005 Standard edition including BIDS installed on my Server. We have restrictions on the number of lines to the Server.
Obviously if I installed Visual Studio 2005 on all desktops that would give me the SSIS we need.
Can I get away with just installing SQL Server Client tools and still create and run SSIS Packages
David
December 19, 2007 at 11:42 am
To create and test SSIS packages through visual studio, you need only install the SQL Client tools which includes BIDS. This will install visual studio with the SQL project types including Analysis Services, Integration Services, and Reporting Services.
To run the SSIS packages without opening them in the visual studio designer, you need to have the SSIS server installed. If you deploy your packages to your server and run them through the SQL Agent, you will be ok. If you have users that want to open Management Studio and execute an SSIS package (without opening it in the designer) the machine running the package needs to be an SSIS server.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply