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 |
|
amit.shinde
Starting Member
9 Posts |
 Posted - 2009-08-18 : 11:55:11
|
| HiI have two packages running...Now I want when package runs it logs into sysdtslog90.When first package runs I want to lock this table sysdtslog90 so that the if the second pacakge runs at the time, it doesnt do the logging at the same time, then after the 1st package get the logging finished the second package begins the logging... |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-18 : 13:33:25
|
| why not just make them consecutive steps in a single job? |
 |
|
|
amit.shinde
Starting Member
9 Posts |
Posted - 2009-08-18 : 15:40:08
|
| Hi, Its not at all confirmed that there are two packages there might be n no of packages |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-18 : 16:29:52
|
| if u want to serialize the logging, need to serialize the execution.by the way, looked at this? http://support.microsoft.com/kb/906563and this: http://sqlblog.com/blogs/andy_leonard/archive/2007/11/11/ssis-design-pattern-etl-instrumentation-part-1.aspx |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-18 : 18:06:29
|
| why do u care what order log records are written? |
|
|
|
|
|
|
Queuing SSIS package