If you’re looking to get started with Data Quality Services (DQS) and Master Data Services (MDS), there are some fantastic resources available on Technet. The site includes videos and slides for full day training sessions on both products. Data Quality Services for SQL Server 2012 Data Quality Basics and Introducing DQS: Video | Slides Knowledge …
Tag Archive: SQL Server 2012
Permanent link to this article: http://www.mattmasson.com/index.php/2012/03/getting-started-with-dqs-and-mds/
Dec
13
Setting a Default Logging Level in the SSIS Catalog
One of the powerful features of the SSIS Catalog is that it can automatically capture logs for packages run on the server. The logging level is set to Basic by default, and can be changed when the package is run on the Advanced tab of the run UI (as shown below. This can also be …
Permanent link to this article: http://www.mattmasson.com/index.php/2011/12/setting-a-default-logging-level-in-the-ssis-catalog/
Dec
13
What Events are Included in the SSIS Catalog Log Levels
Logging Levels Packages run through the SSIS Catalog can automatically have their logs captured in SQL Server 2012. The SSIS Catalog provides four different log levels – None, Basic, Performance, Verbose. The default log level is Basic. The table below shows which SSIS events are captured in the [catalog].[operation_messages] view in the four logging levels. …
Permanent link to this article: http://www.mattmasson.com/index.php/2011/12/what-events-are-included-in-the-ssis-catalog-log-levels/