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)
 ssis log

Author  Topic 

inbs
Aged Yak Warrior

860 Posts

Posted - 2012-08-03 : 08:26:32
hi,

what way do you use of ssis logging?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-08-03 : 10:00:02
you can use flat file log provider to log it to text file or use SQL server log provider. you can even have custom logging as below

http://pragmaticworks.com/Products/Business-Intelligence/BIxPress/ssis-logging-auditing-monitoring.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

inbs
Aged Yak Warrior

860 Posts

Posted - 2012-08-03 : 10:02:53
which way do you preffer?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-08-03 : 10:06:34
i mostly use custom logging as i would like have customised schema for my log table

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

inbs
Aged Yak Warrior

860 Posts

Posted - 2012-08-04 : 14:00:27
i want to make simple log,(without use Event Handlers)
start and end each component,details

can you give me link that i can to start?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-08-04 : 14:35:55
quote:
Originally posted by inbs

i want to make simple log,(without use Event Handlers)
start and end each component,details

can you give me link that i can to start?


the earlier posted link has screenshots explaining various approaches.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -