O'Reilly logo

SQL Server Integration Services Using Visual Studio 2005 by Jayaram Krishnaswamy

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Hands-On Exercise: Transferring Data from a Flat File to a SQL Server Database Table

In order to follow the steps as indicated, you will need access to a table in a database on the SQL Server 2005 as well as knowledge of the nature (format) of the file and its location.

The following are the major steps in this exercise:

  • Use/create a flat text file whose contents need to be transferred.

  • Create a SQL Server database table with columns that can accept the contents of the file created in the previous step.

  • Create a BI Project and add a Bulk Insert Task.

  • Configure the Bulk Insert Task.

  • Build and execute the package.

Step 1: Use / create a Flat Text File whose Contents Need to be Transferred

Normally, this file should be available, as this is the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required