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 ...