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 |
|
dataczar
Starting Member
18 Posts |
 Posted - 2009-06-29 : 17:13:36
|
| I am wondering if there is a better way to perform a task in my package. I have a series of 25 tables that I am loading. I have an Insert Audit ID control flow item for each table. It does the same thing for each, creates an audit id and returns it to the package. I also have an Update Audit control flow item for each table that updates the run times and row counts for each table. I am wondering if I need to have 25 of these control flows tasks or whether I could combine them into one. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-30 : 14:10:12
|
| is that a constant value you insert for all tables? |
 |
|
|
dataczar
Starting Member
18 Posts |
Posted - 2009-07-01 : 00:30:41
|
| A different audit id is generated for each table in a Stored Proc and returned to the package using Execute SQL Task. The update of the audit information also is an Execute SQL Task. |
|
|
|
|
|
|
Efficiency Question