All contents are copyright of their authors.

View All Notifications C Corner Post An Article A Blog A News A Video An EBook An Interview Question Ask Question TECHNOLOGIES ANSWERS LEARN NEWS BLOGS VIDEOS INTERVIEW PREP BOOKS EVENTS CAREER MEMBERS JOBS Importing CSV File Into SQL Server Using SSIS Joginder Banger.

Save The Package In Sql Server How To Import A

Updated date Feb 19, 2015 52.4k 0 0 In this article you will learn how to import a CSV file into SQL Server using SSIS.

The client wants to import many CSV data files into SQLTable.

I have no idea how to do this but my friend once heard about the SSIS package.

So I decided to search on Google and after some time I got the solution using the SSIS package.

Introduction This article describes how to import data into SQL Server.

It will by default select a SQL Server Native Client 10.0 data source.

You can change that depending on requirements.

A flat file is a simple data file with no structured relationship.

A CSV files data is separated by commas as in jogi,singh,banger.

You can see the automatic change of the design when the flat file is selected.

Fig: 4 When columns are selected the view is changed to include a preview of your data.

Fig: 5 If you want to change a column name then select the advanced option and make changes depending on your requirements.

I select the ID column, then checked the Misc column Name option there.

Fig: 6 You can see in the preceding image that I changed the column Name and showed data depending on the format.

Fig: 7 After completing the flat work move to the next option.

Save The Package In Sql Server Password Or If

Enter your server name, then enter your user name and password or if you are working on the local machine then select the use Window Authentication.

IF you enter everything correctly the database dropdown will show your database name otherwise nothing.

Fig: 8.

Note: If you want the same name for the file name as of the table then click the Next button or change the something name changed the table.

Fig: 9 You can save the package for the import and export file.

If you think this is not necessary then just press Next or select otherwise save the SSIS package.

You can check that flat file data shown in the preceding image has been stored in the table.

Final Words I think this is a small article but helpful for everyone.

If you have any query about this article then drop your comments.

Import.CSV Import.CSV to SQL Import.CSV using SSIS SQL Server SSIS.