How to create a script task that uses the SSIS PDW destination adapter The Integration Services Script Task allows you to perform virtually any operation that can be accomplished in a .Net application ...

To add an Azure Data Lake Store File System Task to a package, drag it from SSIS Toolbox to the designer canvas. Then double-click the task, or right-click the task and select **Edit**, to open the ...

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