We are trying data conversion using ssis and facing the following issues:
1. How to default values to table (sql server) through SSIS in the data transfer step. (I used to run an update after the data transform task, but here the table schema does not allow nulls at all during the intial data transfer). It looks to me may be there
is an option somewhere that i need to check for the default values.
2. We want to transfer data to a identity column, knowing that it does not let me export data into that column i actually added a SQL step before the data flow task saying "SET identity_insert off" on that table but still the package fails saying that
cannot insert on identity column.
3.we also want generate a script that shows how the data transformation is done like which table and column is mapped to which destination table and column.
View Complete Post