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 |
|
icw
Constraint Violating Yak Guru
378 Posts |
 Posted - 2010-07-08 : 09:58:26
|
| I have to update a reporting database from a production database on a nightly basis using ssis packages. I have two questions1. Should i put all my packages into one job or create lots of jobs2. When updating, should i just drop and recreate the whole table (I suspect not) or just update where NOT existing in the target tableThanksPS I think i already know my answers but I want to check with you experts out there. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Which would have least overhead