String manipulations with the SSIS Script Component
Problem: Your source data contains a column that should be split in two. In this case there is a name column in an Excel file that contains both the first and last name. The destination database has the first and … Continue reading