From the course: SQL Server 2008 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Creating and executing a simple SSIS package

Creating and executing a simple SSIS package - SQL Server Tutorial

From the course: SQL Server 2008 Essential Training

Start my 1-month free trial

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…

Contents