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 |
|
abhijaiswal.84
Starting Member
29 Posts |
 Posted - 2012-05-29 : 04:37:47
|
| Hi,I want to Transfer the data from 3 Excel files (Same column name for all 3 excel-file) to SQL Server table through SSIS package, with some condition,In excel-sheet there are 25 columns and 572 Rows, the first row is blank next 8 rows are having data in only 'column A' and the 10th Row is having column heading.Now I want when I am transfering data from 3 excel-files to SQL Server table through SSIS package, the data from Row 11 should be inserted into table, as the row 10 will be used for mapping and should iliminate (Remove/ should not Insert) data from row 1 to row 9 in the table.Can you please help me to do this task.Thanks in advance.Abhishek |
|
|
abhijaiswal.84
Starting Member
29 Posts |
Posted - 2012-05-29 : 04:41:22
|
| Here I am using 3 excel source, one Union_all Transformation and one SQL destination, all the data from 3 excel files are going in single SQL Server tableAbhishek |
 |
|
|
Gigabyte
Starting Member
30 Posts |
Posted - 2012-05-29 : 16:39:02
|
| How about using bulk insert ! I believe you need to do little scrubbing work before you load the excel files.SATISH GEDDAMURI |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-05-29 : 17:20:51
|
quote:
Originally posted by Gigabyte
How about using bulk insert ! I believe you need to do little scrubbing work before you load the excel files.SATISH GEDDAMURI
BULK INSERT won't work with Excel files, only CSV or other text formats. |
|
|
|
Gigabyte
Starting Member
30 Posts |
Posted - 2012-05-29 : 19:15:20
|
| My bad ! Overlooked the statement ....trueSATISH GEDDAMURI |
|
|
|
|
|
|
Excel to SQL Server