December 1, 2010 at 12:47 pm
Hi all,
I just got the logging set up and going for one of my packages. Looks like SSIS automatically created a table called dbo.sysssislog under system tables in my DB and is loading the logging data there. My question is: does the logging have to go to a system table named dbo.sysssislog? I didn't see any options to load to a table I want. I'm using SSIS 2008.
Thanks,
Strick
December 1, 2010 at 12:57 pm
The table is always sys.sysssislog although it can be in differend databases. Default is msdb.
To use a different table name, you would have to use another provider; probably you would have to write your own.
December 1, 2010 at 1:04 pm
Ok thanks for your help.
Strick
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply