Sunday, March 25, 2012

Can't find SSIS ?

I have VS2005 and have been using SQL 2000. I installed SQL 2005 Developer but I can't find SSIS anywhere. It is hard to start even the first tutorial if I can't find the program. Was it supposed to be installed with 2005 Developer? Help!

Thanks in advance.

Chuck

Did you select to install Integration Services and the development environment. If you did, the best way to Start to is to open the Business Intelligence Development Studio (BIDS) - find it under your SQL Server group on the Start menu. See http://msdn2.microsoft.com/en-us/library/ms173767.aspx

Start a new Integration Services project ... http://msdn2.microsoft.com/en-us/library/ms141823(sql.90).aspx

If you do not have BIDS installed then you most likely did not install dev tools.

Donald

|||

Did you select SSIS during the install? Note that installing SSIS does not enable you to build packages, only run them.

The SSIS development tool (i.e. BIDS) is installed when you select the "Client Tools" option.

-Jamie

No comments:

Post a Comment