Transforming source columns to create unique destination column in SSIS -
i have been building ssis package transfers data between 2 databases different schemas. in destination database 1 column has unique key constraint, , data needs populated 2 source database columns like: select (lower(left(col1.column1, 5)) + lower(left(col1.column2, 5))) i.e. first 5 characters each column, plus incrementing number @ end if there duplicates. the incrementing number has dependent on first 10 characters every different variation has own incrementing number. ex: dest.column apapapap1 apapapap2 apapapap3 epepepep1 epepepep2 this package run every week, adding necessary column ssis oledb source won't work. so question is: possible carry out transformation in ssis before writing destination database, , if so, how? doing using custom query preferred option here if have in ssis, try generating 2 columns in ssis, 1 appends 2 columns source ( source1 ), , contains these combinations destination (after removing number) ( dest1 ). can configure ...