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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 log error

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 table
What 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.
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -