August 13, 2007 at 12:22 pm
I'm trying to log using the log provider for SQL Server, but I don't know where the data are stored. BOL does not say where (or I did not waste enough time looking). Is it a secret? Reading the logs would be a cool thing to do on occasion!
TIA!
David
September 27, 2007 at 1:34 am
from book "Microsoft SQL Server 2005 Integration services" by Kirk Haselden:
The SQL Server Log Provider adds log entries to the system table called sysdtslog90 and requires an OLEDB connection to an instance of SQL Server and containing the target database name. If the sysdtslog90 table does not exist in the destination database, the SQL Server Log Provider creates it. The default database is MSDB.
Hope this can help you.
Bye.
Moreno
September 27, 2007 at 9:02 am
Thanks Moreno! I finally stumbled across it after creating a package in my own dev database and seeing a strange new table pop up.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply