Solved

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

Posted on 2014-12-22
4
1,341 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

OfficeMate Freezes on login or does not load after login credentials are input.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This Micro Tutorial will give you basic overview of the control panel section on Windows 7. It will depth in Network and Internet, Hardware and Sound, 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.

749 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