Click here to Skip to main content
13,458,837 members
Click here to Skip to main content
Articles » Database » Database » SQL Server » Revisions


10 bookmarked
Posted 12 Jan 2013

SSIS: Load Data in Dimension Table by Merge Join

, 13 Jan 2013
How to load data from an Excel file to load in a dimension table in an incremental way.



Compare Revision Minor Date Status Editor
4 - publicly available No 13-Jan-13 6:03 Available Smitha Nishant
Updates in content. 280 changes had been made.
3 No 13-Jan-13 3:47 Pending mparvez
Title "SSIS: Load Data in Dimension Table by Marge Join" should be "SSIS: Load Data in Dimension Table by Merge Join"
2 No 13-Jan-13 2:09 Pending mparvez
Title need to change "SSIS: Load Data in Dimension Table by Marge Join" instead of "SSIS: Load Data in Dimension Table" because I am writing another tip named "SSIS: Load Data in Dimension Table by SQ
1 No 12-Jan-13 9:28 Available Smitha Nishant
Initial creation


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Software Developer (Senior) icddr,b
Bangladesh Bangladesh
More than 8 years experience on Programming and Project implementation, I was primarily involved with projects for private organization,Govt.(Bangladesh Army,DG Health,RJSC), NGO (SEDF,WFP). Presently I am working at ICDDR,B and enhancing Hospital Management System developed by Microsoft Dynamic NAV and Windows Mobile Application 5.0

An active supporter of Open Source technology, my interested areas are ERP, IT Audit, Data warehouse, BI etc.

Playing Guitar for 15 years, my interested music style is Blues Rock,Neo Classical.


70-540:Microsoft® Windows Mobile® 5.0 - Application Development
MB7-514:Microsoft Dynamics™ NAV 5.0 C/SIDE Introduction
MB7-516:Microsoft Dynamics™ NAV 5.0 Solution Development
MB7-517:Microsoft Dynamics™ NAV 5.0 Installation and Configuration
MB7-515:Microsoft Dynamics™ NAV 5.0 Financials
70-432:Microsoft SQL Server 2008 - Implementation and Maintenance
70-450:PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008
70-448:Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
312-50:Certified Ethical Hacker

Web :
Blog :
linkedin :

You may also be interested in...

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web03 | 2.8.180323.1 | Last Updated 13 Jan 2013
Article Copyright 2013 by mparvez
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid