Lynn Pettis (8/17/2012)
First, why are you copying the records with a different sequence no (really just curious about the business requirement)
Second, why does it have to be done in SSIS? A simple T-SQL statement can do it just as easily. The only thing that bothers me is that you are doubling the number of records in the table, and that could explode you t-log on the table.
There are ways to manage this possibility, but it means knowing more about the data and the table in particular (unique or primary keys to be exact).
i am sorry Lynn, i don't know why that need to do...but this is what my manger ordered me to do so..
we are going to work on the production server ....my higher authorities does not want to look any queries over there....they want everything under SSIS package(only the .dtsx file to be executed)....
that is why i am working on it now...
the main reason behind this is , since we are dealing with million of rows in all the tables....we don't want to load any tables using direct T-SQL statements...becaue due to huge data, the sql server needs to be opened for more than a day....if some one accidently closed the server, then everything will be blown off....so they don't want anything to be transparent...so they came up with SSIS...