November 16, 2012 at 9:36 am
Hi,
I am trying to export only top (100) rows from an excel source. I added the excel file to the source, went to Source properties and changed the OpenRowset from Sales to Sales$A2:D101, so that it would read only first 100 rows. Now, the excel source gives me an error saying "The external columns of component "Excel Source" are out of sync with the data source...."
Can someone please tell me where am i going wrong?
Thanks
November 19, 2012 at 4:26 am
if you will use ssis
pls follow given steps.
(1)create excle connection..
(2) go to excel sourse after that Data acess mode:sql commane
SELECT TOP 100 *
FROM [Sheet1$]
(3) after map the excel sourse to oledb destination...
November 22, 2012 at 11:05 pm
Thanks much 🙂
November 30, 2012 at 4:11 am
col1 col2 col3
5.06.03.5
9.59.86.3
9.06.08.0
Col4col5col6
9.56.08.0
6.39.33.9
8.78.08.8
9.08.36.9
8.69.06.2
I have data like this in excel, how to load into 2 different tables
first table contain col1,col2,col3as columns
second table contain Col4,col5,col6 as columns.
Note: Here the number of columns are fixed(3).
November 30, 2012 at 4:35 am
raghavender.2369 (11/30/2012)
col1 col2 col35.06.03.5
9.59.86.3
9.06.08.0
Col4col5col6
9.56.08.0
6.39.33.9
8.78.08.8
9.08.36.9
8.69.06.2
I have data like this in excel, how to load into 2 different tables
first table contain col1,col2,col3as columns
second table contain Col4,col5,col6 as columns.
Note: Here the number of columns are fixed(3).
Do not hijack other peoples threads, you have already created your own thread here, please be patient, we are all unpaid volunteers who help in our spare time.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply