Calling an SSIS package from another SSIS package is, on the surface, a simple task. You just use the Execute Package Task and point it to a package on a SQL Server ...

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 ...

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 store ...

Many SSIS transformations, such as the Pivot and the Data Profiling Tasks, require that the data being fed into them be sorted. Without first sorting, some ...