Learn more about SQL Server tools

   
   
















Latest from MSSQLTips

Webcast - Improve Any SQL Server Audit with SQL Compliance Manager

Get up to speed on SQL Server 2016

Guide to SQL Server Performance Management with Extended Events

MSSQLTips.com 10 Year Anniversary Celebration

Performance Issues when Updating Data with a SQL Server Linked Server

Faster Way to Transfer Data from SQL Server 2014 to Oracle 11g

Database Cloning in SQL Server for Troubleshooting and Diagnostics

How to Enable Localization Support for SQL Server Analysis Services Dimension Attributes

SQL Server Agent Job Advanced Management

On-Demand Webcast - What's New with High Availability in SQL Server 2016 and Windows Server 2016

Whitepaper - SQL Server HA and DR: A Strategy To Reduce Costs

Whitepaper - SQL Server Query Tuning - A 12-Step Program

On-Demand Webcast - Easily find and fix performance issues using intelligent diagnostics with DBArtisan















SQL Server Integration Services (SSIS) Tutorial

(Introduction)


Overview
SQL Server Integration Services (SSIS) is a tool that we use to perform ETL operations; i.e. extract, transform and load data.  While ETL processing is common in data warehousing (DW) applications, SSIS is by no means limited to just DW; e.g. when you create a Maintenance Plan using SQL Server Management Studio (SSMS) an SSIS package is created.  At a high level, SSIS provides the ability to:

  • retrieve data from just about any source
  • perform various transformations on the data; e.g. convert from one type to another, convert to uppercase or lowercase, perform calculations, etc.
  • load data into just about any source
  • define a workflow

The first version of SSIS was released with SQL Server 2005.  SSIS is a replacement for Data Transformation Services (DTS) which was available with SQL Server 7.0 and SQL Server 2000.  SSIS builds on the capabilities introduced with DTS.

In this tutorial we will step through a number of topics that you need to understand in order to successfully build an SSIS package.  Our high level outline is as follows:

  • Creating SSIS packages with SQL Server Management Studio (SSMS)
  • Business Intelligence Development Studio (BIDS)
  • Creating a simple SSIS package in BIDS
  • Deploying SSIS packages
  • Executing SSIS packages

You can either use the outline on the left or click the arrows to the right or below to scroll through each of these topics.

Additional Information

 







 
More SQL Server Solutions



 

Follow

Get Free SQL Tips

Twitter

LinkedIn

Google+

Facebook

Pinterest

RSS

Learning

DBAs

Developers

BI Professionals

Careers

Q and A

Today's Tip

Resources

Tutorials

Webcasts

Whitepapers

Tools

Search

Tip Categories

Search By TipID

Authors

Community

First Timer?

Pictures

Free T-shirt

Contribute

Events

User Groups

Author of the Year

More Info

Join

About

Copyright

Privacy

Disclaimer

Feedback

Advertise

Copyright (c) 2006-2015 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.