Solved

how to import multiple CSV files in folder into SQL Server 2012

Posted on 2014-12-22
4
1,222 Views
1 Endorsement
Last Modified: 2016-02-15
I have SQL Server 2012.  I want to import about 350+ CSV files located in a local folder of SQL 2012 server.  I only need a one-time import at this time.  I am new to SQL Server 2012, but have researched my problem extensively with BCP, Bulk Insert, OPENROWSET, and SSIS. Please assist with the easiest way possible. Thank you.
1
Comment
Question by:blackcatkempo
  • 2
4 Comments
 
LVL 65

Accepted Solution

by:
Jim Horn earned 250 total points
ID: 40513267
Shove them in the same folder, then in SSIS use a For Each File Loop to loop through all files to set the source of a data pump, with the destination being the SQL table.

That assumes that the files are exactly the same schema, and they are inserting into the same SQL table.
1
 

Author Comment

by:blackcatkempo
ID: 40521278
Do you have a good tutorial to follow using Microsoft Visual Studio 2012 Shell (Integrated) SQL Server Data Tools   11.1.41025.0?
0
 
LVL 15

Assisted Solution

by:Vikas Garg
Vikas Garg earned 250 total points
ID: 40521726
Hi,

I think the following link would help you to implement the same.

http://www.mssqltips.com/sqlservertip/2874/loop-through-flat-files-in-sql-server-integration-services/
0
 

Author Closing Comment

by:blackcatkempo
ID: 40522593
Awesome when it finally worked!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no backā€¦
This Micro Tutorial will go in depth within Systems and Security in Windows 7 and will go into detail regarding Action Center, Windows Firewall, System, etc. This will be demonstrated using Windows 7 operating system.
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply. This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.

766 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question