Create and Execute a Simple SSIS Package in SQL Server 2008


show more Creating and executing a simple SSIS package provides you with in-depth training on Business. Taught by Simon Allardice as part of the SQL Server 2008 Essential Training show less
please wait ...

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 So...

Creating and executing a simple SSIS package
Video duration: 7m 35s 6h 54m Beginner

Viewers:

Creating and executing a simple SSIS package provides you with in-depth training on Business. Taught by Simon Allardice as part of the SQL Server 2008 Essential Training

Subjects:
Business Developer IT
Software:
SQL Server
Author:
please wait ...