SSIS Package For Conversion Of Flat File To SQL Server

SSIS Package For Conversion Of Flat File To SQL Server

In this tutorial i will explain how to use SSIS Package For Conversion Of Flat File To SQL Server.Or you can say Importing data from a text file to the SQL Server using SSIS(SQL Server Integration Services).In SQL Server 2012 Business Intelligence has been replaced by SQL Server Data Tools.

Steps:

1. Go TO Start > All Programs > Microsoft SQL Server 2012 > Click on SQL Server Data Tools, In SQL Server 2008 or 2005 use Business Intelligence.

2. Create A New Integration Service Project.

3. Now add new connection, Right click on Connection Manager and add a flat file Connection.

4. It will open a window choose Flat file from your system.If the first row of file contains the column name then check the check-box(Columns names in the first data row).You can check preview of data by clicking on preview link.

5. Now Add OLEDB Connection.

6. New window will open, create a new OLEDB connection by clicking on NEW or use and Existing one.

7. New window will open, Now choose Server name, authentication mode and database which you want to use.Now Test Connection if connection is succeed click OK.

8. Click on Data Flow Task Tab.Now click on Source Assistant and choose Flat File and choose existing connection we have created earlier.In SQL Server 2005 and 2008 Source Assistant is Replaced by Data Flow Sources.

9. Click OK and Now click on Destination Assistant and choose SQL Server and then existing Connection.IN SQL Server 2005 and 2008 Destination Assistant has was used as Data Flow Destinations.

10. Now our Data Flow task is completed, we can also do some configuration like: Mapping of columns, Creation of table.For that Double click on OLEDB Destination.

11. Now Click OK, and save your package.Then run it.Enjoy…