SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 SSIS with Express server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kev921hs
Starting Member

1 Posts

Posted - 05/02/2013 :  22:47:56  Show Profile  Reply with Quote
Hello - I'm using SQL Server 2012 Express and want to import data from 400+ separate Excel files, which are all in one folder, into a table. From everything I read, using BIDS, a ForEachLoop and SSIS are all the way to go. However I can't save an SSIS package in Express, and can't create an Integration Services Project.

Is there any way to do a batch import in Express? Or do I have to import each file manually?

Thanks in advance,
Kevin

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 05/03/2013 :  03:09:57  Show Profile  Reply with Quote
nope.Unless you've atleast dev edition you can use SSIS. The only other is to write a procedure which makes use of BULK INSERT or OPENROWSET based logic to get file data onto table. You need then loop it for 400 + files

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000