Author |
Topic |
inbs
Aged Yak Warrior
860 Posts |
Posted - 2008-11-30 : 12:04:01
|
what the steps that i can mage join between 3 tables or more?(i put two tables with merge join and than he asked me for sort,so i sort each table,how i add to join the third table?)thanks |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-30 : 12:12:00
|
just take the output of merge join and thirdtable's oledb source tasks output and join them with another merge join. then choose appropriate columns as join columns and select inner or left or full join. |
 |
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2008-11-30 : 12:40:28
|
so if i have more than 3 tables,example: oledb table1->sort -->merge join(1,2)->sortoledb table2->sort -->merge join(1+2,3) oledb table3->sortfor this you mean?(it isnt so nice?) |
 |
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2008-11-30 : 12:43:41
|
oledb table 1 oledb table2 | | sort sort oledb table 3 megere join(1,2) | | sort sort merge join(1+2,3)i hope that now i more clearly |
 |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-30 : 12:45:03
|
you dont require special sort tasks if you can bring data in sorted form from tables using order by in select statement and choosing query option. |
 |
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2008-11-30 : 12:51:02
|
never mind.another question:after i make a job on a package that in placed of older.i understand that i need to bring the package to msdb in managment studio and the job run the msdb,is it right?examplei have a Dailyjob package DailyPackage (D:\SSIS\DailyPackage.dtsx)every day the job execute the package.i think that it isnt the right way,how my system still wok,isnt it? |
 |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-30 : 12:56:14
|
yup. you need to import package to msdb and job will call it daily. |
 |
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2008-11-30 : 13:41:15
|
what i need to choice,the package or the bin of the package?my job is on the bin of the package.(and if i have any change in the package,the msdb will know the change in the package or i need to load it every time when i do any change in the package)? |
 |
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2008-11-30 : 13:55:15
|
visakh16,i have one more question,i must to use the ssis-components or i can still use sql task?like to make join or "case" statment.it more simple for me to use sql task,i must to use the components in ssis?sorry of many questions |
 |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-01 : 00:15:28
|
quote: Originally posted by inbs visakh16,i have one more question,i must to use the ssis-components or i can still use sql task?like to make join or "case" statment.it more simple for me to use sql task,i must to use the components in ssis?sorry of many questions
you can use sql task provided all the tables are from same server. merge join task is used only when the data is from different sources (servers) and you want to join them based on common field. |
 |
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2008-12-01 : 01:08:50
|
what objects i need to use when my tables is from same servers,and from diffrent servers?i bring the data to my server and then develop the DWH. |
 |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-01 : 01:17:33
|
quote: Originally posted by inbs what objects i need to use when my tables is from same servers,and from diffrent servers?i bring the data to my server and then develop the DWH.
as said earlier, if you want to join data from tables based on some common field and if both tables are in same server, you can use execute sql task or even OLEDB task if inside a data flow with sql command option (rather than default table or view option).In cases where your data comes from more than 1 servers and you want to join data from different source/servers (all of them not necessarily SQL Server can be other db servers or even from flat file like csv,excel,txt documents), thats when you use merge join task to join them. |
 |
|
|