SSIS Package for merging data sources and applying transformations
Posted by Ravi Khanal on Dec 14, 2008
Scenario:
I have file in different heterogeneous sources like Text file and Excel File and I want to merge it into the SQL Server Table. But before loading the data into SQL Server table I have to change the First Name Column into Upper Case and also I need to give 20% raise in the salary. So I should have the proposed salary column added to the table.
Solution:
So First I need to have the data flow task for this.
Then in the data flow the package would be like this:
Posted in SQL Server 2005 || No Comments »
