From the course: SQL Server 2008 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Creating and executing a simple SSIS package - SQL Server Tutorial
From the course: SQL Server 2008 Essential Training
Creating and executing a simple SSIS package
I am going to illustrate how to create a basic package by doing something very simple. And I'll make a new project here in the Business Intelligence Development Studio. So create a new project. It's going to be Integration Services and I am going to call it the FlatFileTransform. Because we don't actually need to move our data in or out of SQL Server. That's an easy mistake to make. Yes, Integration Services runs as part of SQL Server but it's quite happy to move information from an Access database into an Oracle database or from a flat file into Access or from SQL out into Teradata. Whatever you can connect to, it will work with. So I am going to begin with about as simple as you can get. One Data Flow Task. Our entire package is going to consist of this one step. Now inside it, we will have several steps, what are we going from, what are we going to, but this will do. So I double click it and I jump into the one Data Flow Task. What I am going to set up is a Flat File Source. I am…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
(Locked)
Introduction to SQL Server Integration Services (SSIS)1m 57s
-
(Locked)
Using Business Intelligence Development Studio (BIDS)6m 59s
-
(Locked)
Creating and executing a simple SSIS package7m 35s
-
(Locked)
Importing packages into SQL Server Management Studio3m 21s
-
(Locked)
Scheduling jobs with SQL Server Agent4m 49s
-
(Locked)
-