Data Taps

This Video Tutorial illustrates how to do logging with Data Taps.

Data Taps store data in the specific point of the time of a data  path of a data flow to dump files which will be structured as text comma separated value files. for adding data tap you would require to use add_data_tap stored procedure in the SSIS Catalog. this stored procedure accespts execution_id (which would come as a result of create_execution stored procedure).

In this video you will learn call add_data_tap stored procedure and how to set parameters to add a data tap on a data path in data flow of a package.