This post was published to VJatBI at 11:08:12 AM 9/14/2013

Introduction to SSIS SQL Server Integration Services

Introduction SQL Server Management Studio SSMS: SQL Server Management Studio is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SQL Server Management Studio combines a broad group of graphical tools with a number of rich script editors to provide access to SQL Server to developers and administrators of all skill levels.SQL Server Management Studio combines the features of Enterprise Manager, Query Analyzer, and Analysis Manager, included in previous releases of SQL Server, into a single environment. In addition, SQL Server Management Studio works with all components of SQL Server such as Integration services, Reporting Services and Analysis Services. Developers get a familiar experience, and database administrators get a single comprehensive utility that combines easy-to-use graphical tools with rich scripting capabilities.

SSMS screen shot with a new query

BIDS Business Intelligence Development Studio

Business Intelligence Development Studio is Microsoft Visual Studio with additional project types that are specific to SQL Server business intelligence. Business Intelligence Development Studio is the primary environment that you will use to develop business solutions that include Analysis Services, Integration Services, and Reporting Services projects. Each project type supplies templates for creating the objects required for business intelligence solutions, and provides a variety of designers, tools, and wizards to work with the objects.

From the Start Menu (Select Visual Studio 2012)

Select File -> New -> Project and you will be on the following screen

Screen Shot of BIDS New Project for SSIS

SSIS Introduction:

Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions.

You use Integration Services to solve complex business problems by:

copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning & mining data, Managing SQL Server objects and data.

The packages can work alone or in concert with other packages to address complex business needs.

Integration Services can extract and transform data from a wide variety of sources such as

XML data files, flat files, relational data sources, Load the data into one or more destinations.

Integration Services includes a rich set of

built-in tasks and transformations; tools for constructing packages; Tools for Integration Services service for running and

managing packages. You can use the graphical Integration Services tools to create solutions without writing a single line of code; or you can program the extensive Integration Services object model to create packages programmatically and code custom tasks and other package objects.