SSIS - How to transform data and push transformed data into Destination database
-
Hi, I am working on SSIS to perform following job. I am copying data from AS400. Now I want to modify the data So, for each record, if the claim number is 123456789..., change it to AAA456789... (you will overlay the first 3 characters). After this transformation, I need to push this data into SQL server. Please advise me how can I do this using SSIS. thanks in advance
CodeManiac xxxxxxxxxx xxxxxxxxxx
-
Hi, I am working on SSIS to perform following job. I am copying data from AS400. Now I want to modify the data So, for each record, if the claim number is 123456789..., change it to AAA456789... (you will overlay the first 3 characters). After this transformation, I need to push this data into SQL server. Please advise me how can I do this using SSIS. thanks in advance
CodeManiac xxxxxxxxxx xxxxxxxxxx
Use split transformation to split data in two types: one where claim number is 123456789 and everything else. Then use derived column transformation to make necessary changes.
Giorgi Dalakishvili #region signature My Articles Asynchronous Registry Notification Using Strongly-typed WMI Classes in .NET [^] My blog #endregion