Execute SQL tasks run stored procedures or SQL queries from SSIS packages. A task executes any SQL statements that have been passed to it in sequential order. It provides you with a handy way to ...

Many new features of SQL Server 2008 have grabbed the headlines in the past year or so but quietly Microsoft has been enhancing SQL Server Integration Services also.

How to Connect to MySQL in SSIS. Every business intelligence solution needs data, which might come from a variety of sources and in different formats. Microsoft SQL Server Integration Services, or ...

Attunity, a provider of real-time data integration and event capture software, has introduced a suite of Operational Data Replication (ODR) solutions integrated with Microsoft SQL Server Integration ...

Designed and integrated into SSIS, Attunity SQL Server -CDC for SSIS integrates SQL Server data efficiently and in real-time. Dramatically simplifying the creation of CDC solutions, accelerating ...

The Microsoft SQL: Designing a Data Warehouse, Microsoft SQL: SSIS, and Microsoft SQL: Data Quality courses are available as part of a CBT Nuggets subscription.