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.
| 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? |
 |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-09-23 : 13:58:39
|
| What is the error? |
|
|
|
junior6202
Starting Member
45 Posts |
|
|
|
|
|
Import multiple files to SQL table