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 |
|
Anand.A
Posting Yak Master
109 Posts |
 Posted - 2011-12-09 : 01:42:45
|
| hii am having 2 excel sheetone sheet contain 10 rows, another sheet contain 300 rowsi want to join this two, but now i want to get only 10 rows in my 1st excel sheet how to get that in ssisreply plzanand |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-09 : 01:47:19
|
| add a data flow task in ssis and use a excel source inside it connect to sheet1 for getting the 10 rows------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Anand.A
Posting Yak Master
109 Posts |
Posted - 2011-12-09 : 01:52:26
|
| i am having 2 excel sheet 1st sheet a,having 10 rows 2nd sheet b.having 300 rows1 st sheet id column using merge join i connect to b sheet id column,after joiningtotally i am getting 256 rows i dont want all the rows i want only 1st a sheet 10 rows only how to do thisanand |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-09 : 01:58:12
|
| then why should you merge? isnt it enough to use only first sheet alone?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Anand.A
Posting Yak Master
109 Posts |
Posted - 2011-12-09 : 02:05:33
|
ya thanks..how to get distinct data from excel sheetquote:
Originally posted by visakh16
then why should you merge? isnt it enough to use only first sheet alone?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
anand |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-09 : 03:35:02
|
| when you create an excel source you'll always specify a sheetname so that it fetches data only from it? isnt that enough?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
excel sheet