I have a requirement where i had to migrate the table structure and data from ODBC database to SQL Server. I have dynamic source reader that uses sql query from variable to get the data and the next step is to get the create statement and create table and
then to insert data. how can i get Create Statement the destination produces and use sql task to create the table and then insert the data using data flow task.
View Complete Post