better way for moving data from one to three table
Database
1
Posts
1
Posters
0
Views
1
Watching
-
hi all, I am using sql server 2005. I making one web form where data from one table(temporary table) is moved to three table two is header and one is detail. i would like to know is making a package is better option or directing writing procedure to move data in respective table is good. Perfomancewise which is fast.or if any other better option is there plaese guide me. If making ssis packge is better please give me useful. please help. Thank you
regards imran khan