February 20, 2012 at 2:22 pm
I need to determine when a DTS package was executed and by who? Is this information captured in any of the database/table and if so where can I find them?
Thanks,
Sean
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
February 20, 2012 at 2:39 pm
I might add that this was a manual run of the package. Not scheduled through Jobs nor is there any configured logging in the package itself.
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
February 20, 2012 at 2:39 pm
In MSDB there is a sysdtspackages table but it won't return the information you are lookign for. If the DTS Packages are executed by SQL Server Job then you can get the information from sysjobs and sysjobactivity table.
Checkout this post for addiitonal info.
http://www.sqlservercentral.com/Forums/Topic419224-146-1.aspx#bm419807
February 20, 2012 at 4:56 pm
Thanks for the reply. Unfortunately the package was run manually outside a job. Thre is no logging in the package and no auditing configured on the server. It was also ran using a SQL Login so anyone that had access to the DTS package could have ran it. I think this one go's into a blackhole.
SQLback (2/20/2012)
In MSDB there is a sysdtspackages table but it won't return the information you are lookign for. If the DTS Packages are executed by SQL Server Job then you can get the information from sysjobs and sysjobactivity table.Checkout this post for addiitonal info.
http://www.sqlservercentral.com/Forums/Topic419224-146-1.aspx#bm419807
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply