To verify the result set value : use one more execute sql task and write insert statement into one temp table, pass the parameter from the 1st sql execute task.

Sry ... If I am not clear in explaining my requirement.

when I click on the 1st level report figure say "111" then and there the detailed level report has to...

the drill through action has to download/export the datailed level report...

Hi,

Did you get the solution ??? @50th row I have string... the destination data type is varchar only. now it is storing as NULL.

it is not working for me.

Plz suggest...

Hmm good Idea and that solves my problem If I can change the source(Excel) but here I don't have to change the structure.

Can you plz explain the process how exactly...

In my actual source are 32 tables i can't proceed with static values in derived column. as the tables are subject to increase... how to hold the header and insert...

Thanks a lot for your support...Yes, we can add derived column but how can I hold the column of the each table ? and I need to insert the header...

No No ... If you can go to the post there you can find 3 sample tables in a single excel sheet, from each table one specific column is need...

thanks for response...

In short , I have excel sheet which has 32 tables... each table has header , the column in the header need to be stored as...

Thanks for Response...

here three tables(I have 32 tables in actual source workbook) are in a singe worksheet(Say sheet1).

Here the no of rows in each table is different so I can't...

ok thank you, ill try. if i structured any where ill come back to you , thank you again.

Thank you ,could you plz provide the sample code, i dont no know how to write the code.

col1 col2 col3

5.0 6.0 3.5

9.5 9.8 6.3

9.0 6.0 8.0

Col4 col5 col6

9.5 6.0 8.0

6.3 9.3 3.9

8.7 8.0 8.8

9.0 8.3 6.9

8.6 9.0 6.2

I have data like this in excel, how to load into 2 different tables

first table contain col1,col2,col3 as columns

second table contain Col4,col5,col6 as columns.

Plz help me how to do...

col1 col2 col3

5.0 6.0 3.5

9.5 9.8 6.3

9.0 6.0 8.0

Col4 col5 col6

9.5 6.0 8.0

6.3 9.3 3.9

8.7 8.0 8.8

9.0 8.3 6.9

8.6 9.0 6.2

I have data like this in excel, how to load into 2 different tables

first table contain col1,col2,col3 as columns

second table contain Col4,col5,col6 as columns.

Note: Here the number of columns...

col1 col2 col3

5.0 6.0 3.5

9.5 9.8 6.3

9.0 6.0 8.0

Col4 col5 col6

9.5 6.0 8.0

6.3 9.3 3.9

8.7 8.0 8.8

9.0 8.3 6.9

8.6 9.0 6.2

I have data like this in excel, how to load into 2 different tables

first table contain col1,col2,col3 as columns

second table contain Col4,col5,col6 as columns.

Note: Here the number of columns...