?
Solved

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

Posted on 2014-12-22
4
Medium Priority
?
1,934 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 66

Accepted Solution

by:
Jim Horn earned 1000 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 1000 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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

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.
When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
This Micro Tutorial will teach you how to the overview of Microsoft Security Essentials. This is a free anti-virus software that guards your PC against viruses, spyware, worms, and other malicious software. This will be demonstrated using Windows…
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
Suggested Courses

764 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