hi! above examples are working when primary key column data type is int ,but not in case of var char , as i have course in course_dim table,what to do with this case?? 2)when it found & loaded the new row dwh,next time it again loading that same one along new rows,why?mhassanshahbaz

hi! above examples are working when primary key column data type is int ,but not in case of var char , as i have course in course_dim table,what to do with this case?? 2)when it found & loaded the new row dwh,next time it again loading that same one along new rows,why? mhassanshahbaz Hi, for first question: you can use varchar, as primary key, and you can use varchar types as joining fields in lookup, what is your problem with it? did you received any error? what is error message? for second question: tell us what did you do till now , there should be something wronghttp://www.rad.pasfu.com

this is good article on how to do Incremental load with SSIS: http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/62063/http://www.rad.pasfu.com

also note that you can raise up performance of lookup transform within incremental load with Cache, take a deep look on this article too: http://blogs.msdn.com/b/mattm/archive/2008/10/18/lookup-cache-modes.aspxhttp://www.rad.pasfu.com

thanks dear:D one more question here for you :) http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/c05c5c4f-2b4e-4c7e-9cd6-216763fe9406mhassanshahbaz

hi! I`m working on a university datawarehouse which load data from text,acess,excel source and load into dimensions and fact tables. Data warehouse is loaded after 1 semester i.e if student cs-01/islamabad was in 5th semester and his data for 4 semesters should have been loaded to data warehouse,now after the end of 5th semester his data for 5th semester will be uploaded,i wanted to know how to make incremental load possible that it load data 1)only for new students 2)students whose data has been modified as i gave example dwh load statistics of new students and upgrade statistics of students whose semester has changed(from 4th to 5th),courses added,marks for new courses,gpa of 5th semester etc but registration no ,dept.,gender,date of registration and campus etc remains same.. thanks! mhassanshahbaz