Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Import multiple files to SQL table

Author  Topic 

junior6202
Starting Member

45 Posts

Posted - 2014-09-23 : 11:40:48
Hi All,

I have over 600+ Excel .xlsx file that I have been trying to import to Sql database table. I've been trying to complete this task with SSIS but no luck yet. I have seen several videos and read articles but when I run the package the source is validated but I always get an error in the destination. I am using Excel 2010 and SQL Server 2012. Any help will be greatly appreciated. Thank you in advance.

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2014-09-23 : 13:43:49
Are you able to import a single file - even if only to test?
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-09-23 : 13:58:39
What is the error?
Go to Top of Page

junior6202
Starting Member

45 Posts

Posted - 2014-09-23 : 14:15:14
Hi James,

I was able to import a single file at the beggining by following this tutorial https://www.youtube.com/watch?v=79mi31caAag but after the it just kept failing.
Go to Top of Page
   

- Advertisement -