Learn more about SQL Server tools


Latest SQL Server Tips

Free SQL Server Learning

Deploying Applications in Azure without Configuration Limitations


Get your SQL Server in shape this Spring with Spotlight on SQL Server


Accidental DBA or DBA We've got You Covered with SQL Diagnostic Manager


Upgrade Strategies for Highly Available SQL Server Environments

Business Intelligence Development Studio (BIDS)


BIDS is the tool that we use to develop SSIS packages.  It provides an intuitive interface based on Microsoft's Visual Studio product which has been used by developers for many years.  This is a departure from DTS which used SQL Server Enterprise Manager as the tool to design packages.  While there are some differences, you will probably find that BIDS is much easier to use, although there may be a little bit of a learning curve.  This section will provide an introduction to BIDS and a review of an existing SSIS package.

BIDS is included with SQL Server.  It is installed when you select client tools during the SQL Server installation.  After you install BIDS, you can launch if from the Microsoft SQL Server program group.  

Sponsor Information