Preview Content - log in or become a member

How to Create SSIS Package

Video



Are you a member? Log In

or check membership plans

Plans:
Bronze
Silver
Gold
6 Courses
T-SQL (3), SSRS (1), SSIS(1), Excel (1)
Watch Video
75 Mini Courses
T-SQL (34), SSRS (7), SSIS(16), + more
300+ videos and 300+ Articles
38
(part of
Courses)
Progress Tracking
21 Interview Q&As pages
T-SQL (8), SSRS (3), SSIS(4), Other (6)
Forum
11 Webinar Recordings
T-SQL (1), SSRS (9), Career(1)
1 DIY Project (beta)
70-461 Tests
Watch Video
60 days, 100% Money Back Guarantee
Instant Activation
Duration:
(one off payment,
not a subscription)
Bronze
Silver
Gold
1 month $19
sign up
$24
sign up
$29
sign up
3 months 33% off
(2 months + 1 free)
$39
sign up
$50
sign up
$60
sign up
6 months 40% off
(3.6 months + 2.4 free)
$68
sign up
$86
sign up
$104
sign up
1 year 50% off
(6 months + 6 free)
$114
sign up
$144
sign up
$174
sign up
2 years 60% off
(9.6 months + 14.4 free)
$182
sign up
$230
sign up
$278
sign up
lifetime >60% off
(12.5 months + a lot for free)
$239
sign up
$302
sign up
$365
sign up



Article

If you are new to SSIS and would like to create your first SSIS package then below is a simple example with step by step instructions which will show you how to create an SSIS package in bids. I will use SQL Server Integration Services 2008 R2 and Visual Studio 2008 (instructions should be very similar for 2008 and 2005). This tutorial is for beginners and will not be following best practise which includes using variables and package configuration. At the end of tutorial I will post extra materials (once I create them) which will include best practise and package deployment.

If you need SSIS Overview before you start than please visit the following link SSIS Package

Create SSIS Package – Purpose

The purpose of this package is to load employee data from a CSV file into SQL Server database new employee table.
 

Create SSIS Package – Prerequisites

In order to complete this tutorial you will need:

  • SQL Server 2008 R2 with default localhost instance and BIDS (should work on 2008 and 2005)
  • Employee CSV file which you should save in location you will remember. Download Employee CSV file

 

How to create an SSIS Package

 

First create SSIS Project using BIDS (For more information visit Create SSIS Project)

Below is example of an empty package. I have highlighted the elements we will use and briefly discuss it below (you can ignore the rest):
create ssis package empty

Solution Explorer - on the right you see solution explorer with your SSIS project (first icon from top). If you don’t have it go to view//solution explorer. In majority of cases you will use SSIS Packages only. The rest is not used in practise (best practise).
Package tab - In middle we have our ‘package.dtsx’ opened which contains control flow, data flow that we will use.
Toolbox - This shows ‘tools’ (items/tasks) that we can use to build our ETL package. Toolbox is different for control flow and data flow tabs in the package.
Control Flow - Here you will be able to control your execution steps. For example you can log certain information before you start the data transfer, you can check if file exists, and you can send an email when a package fails or finishes. In here you will also add a task to move data from source to destination however you will use data flow tab to configure.
Data Flow - This is used to extra source data and define destination. During the "data flow" you can perform all sorts of transformation for instance create new calculation fields, perform aggregations and many more.

Let’s get to work.
Make sure you are in control flow tab in SSIS Package designer and in the toolbox find data flow and drag into empty space in control flow pane.



Are you a member? Log In

or check membership plans

Plans:
Bronze
Silver
Gold
6 Courses
T-SQL (3), SSRS (1), SSIS(1), Excel (1)
Watch Video
75 Mini Courses
T-SQL (34), SSRS (7), SSIS(16), + more
300+ videos and 300+ Articles
38
(part of
Courses)
Progress Tracking
21 Interview Q&As pages
T-SQL (8), SSRS (3), SSIS(4), Other (6)
Forum
11 Webinar Recordings
T-SQL (1), SSRS (9), Career(1)
1 DIY Project (beta)
70-461 Tests
Watch Video
60 days, 100% Money Back Guarantee
Instant Activation
Duration:
(one off payment,
not a subscription)
Bronze
Silver
Gold
1 month $19
sign up
$24
sign up
$29
sign up
3 months 33% off
(2 months + 1 free)
$39
sign up
$50
sign up
$60
sign up
6 months 40% off
(3.6 months + 2.4 free)
$68
sign up
$86
sign up
$104
sign up
1 year 50% off
(6 months + 6 free)
$114
sign up
$144
sign up
$174
sign up
2 years 60% off
(9.6 months + 14.4 free)
$182
sign up
$230
sign up
$278
sign up
lifetime >60% off
(12.5 months + a lot for free)
$239
sign up
$302
sign up
$365
sign up


Did you find this page useful?
+9  |  -0
(9 Votes)
Live Chat (Log in)