Most RecentMost ViewedMost LikesSSIS Catalog - Backup and RestoreFirst published on MSDN on Mar 23, 2012 Integration Services catalog (SSISDB) uses the encryption mechanism available in SQL Server to protect its sensitive data.Changing Variable Scope and other EnhancementsFirst published on MSDN on Mar 12, 2012 In SQL Server 2012, SSIS includes some very useful enhancements to package variables.SSIS and PowerShell in SQL Server 2012First published on MSDN on Nov 17, 2011 This post is from Parth Shah, a Software Development Engineer in Test on the SSIS Team.How to add Reference Data Services in Data Quality Services (DQS)First published on MSDN on Jul 20, 2011 SQL Server Data Quality Services (DQS) is a knowledge-driven data quality solution.Using the SSIS DQS Cleansing ComponentFirst published on MSDN on Jul 18, 2011 As part of our DQS CTP3 offering, we are releasing a new DQS SSIS component.Changes to the Execute Package TaskFirst published on MSDN on Jul 18, 2011 Todays post is from Terri Chen, a developer on the SQL Server Integration Services team.Installing and Configuring Data Quality ServicesFirst published on MSDN on Jul 17, 2011 After you’ve downloaded Denali CTP3, it’s time to install DQS!Here you can find some important information that will help you install and configure DQS successfully.LEFT Function in SSIS ExpressionsFirst published on MSDN on Jan 06, 2011 There are a number of small changes to Integration Services in SQL Server Denali that might not be immediately apparent.Introducing Data Quality ServicesFirst published on MSDN on Jul 12, 2011 Welcome to the SQL Server Data Quality Services Team Blog! SQL Server Data Quality Services (DQS) is the new innovative data quality product delivered as part of SQL Server “Denali” release.Balanced Data Distributor (BDD) for SQL Server 2012 is Now AvailableFirst published on MSDN on Jun 20, 2012 The Balanced Data Distributor (BDD) transform has updated and released for SQL Server 2012.