Search results for 'app:weblogs' matching tags 'SQL Server', 'SSIS', and 'logging'

Auditing and Logging - make use of SSIS in SQL Server

Anonymous — Tue, 28 Apr 2009 05:00:00 GMT

For a mintue I was thinking why I should post in this section, the variability is as per the law applicable to Financial sector to make sure the financial statement that a company reports is legitimate and that there’s no room for someone to manipulate it. As you can imagine, preventing the manipulation of the financial statement has a lot of IT impact. Some interpret the law to mean that you must audit who loaded each row into a database and when it arrived. So how can SQL Server features can help...(read more)

SQL Server 2005 logging providers - make best use for SSIS packages to diagnose the issues

Anonymous — Wed, 09 Apr 2008 05:00:00 GMT

Log or trace of activities will help you to get detailed information on what's going wrong, that too very useful for ETL based processes. In this regard within SQL Server 2005 using SSIS you can enable such logging within the package's runtime. This will allow you to log the output to 5 providers, such as text file, SQL Profile trace, SQL Server table, XML file or a Windows Event log. Further you can take advantage of writing the same to 2 different providers, such as building custom logging provider....(read more)