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 |
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-07-05 : 12:04:36
|
I am trying to conofigure logging errors from the ssis package into a sql server table.In configure ssis logs window I have created a row in the select the logs to use for the containser and the configuration for this is set to poiint to the database. The provider type is ssis log provider for sql server.Note taht I do not get the expected dbo.sysssislog tableWhat do I do next?Thank you |
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-07-05 : 12:36:05
|
Have you added a connection for the log provider?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-07-05 : 13:56:39
|
did you map it to point to table in database. also have you added details of what all events need to be logged?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|