Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imranabdulaziz
Yak Posting Veteran
83 Posts |
 Posted - 2008-02-20 : 03:41:19
|
| 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 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-20 : 04:19:02
|
| Is the data for temp table coming from the form? How are you populating this temp table currently? by inline queries within the application? |
 |
|
|
imranabdulaziz
Yak Posting Veteran
83 Posts |
Posted - 2008-02-20 : 04:48:02
|
| Actually temp table is there is sql server.I am making draft in form and chages is finnally reflected back to temp table then on close day button click i would like to trafer these record to respective tableThank you. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-20 : 05:12:08
|
| Do you mean to say the temp table will hold the results until end of each day? You will have an open connection with server for the whole day with server? |
|
|
|
|
|
|
better way for moving data from one to three table