package

Question

package

miriyalasrihari

Ten Centuries

Points: 1225
More actions
January 13, 2011 at 12:45 am

#149649

table 1 (db1)
----------------------
id | name
----------------------
1 | a
2 | b
3 | c
4 | d
5 | e
------------------
table t2(db1)
------------------------
id2
------------------------
6
7
8
9
10
------------------------
both these tables are in MSSQL server 2008 database(one database say db1)
how to merge both tables(using ssis package) to get result like
table t3(db1)
------------------------
id | name |id2
------------------------
1 |a |6
2 |b |7
3 |c |8
4 |d |9
5 |e |10
------------------------
plz hlp me.......
[font="Verdana"]SRIHARI(:~[/font]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Cadavre SSC-Forever Points: 41690 More actions · Answer 1

What's the relationship between the two tables?

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

miriyalasrihari Ten Centuries Points: 1225 More actions · Answer 2

thanks for replay

no relation ship exits between those tables.....

[font="Verdana"]SRIHARI(:~[/font]

Cadavre SSC-Forever Points: 41690 More actions · Answer 3

If there's no relationship then how do you know whether or not you have correct results? You could just merge the tables, but you can't g/tee the results.

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/