I have a DTS pacakge (as a structured file) which is
scheduled through Jobs in SQL agent. I have enabled
pacakge logging for this package. This DTS pacakage is
invoked through many jobs which can run at same time. So,
the sysdtspackagelog and sysdtssteplog will be populated
with logs from instances of the dts package which was
invoked from many jobs (with different parameters). As
logging is based on the DTS package name, we are not able
to differentiate between the logs from different jobs. Is
there any way to relate the pacakge instance in
sysdtspackagelog and job running instance?
Thanks in Advance,
Arun