Database Reference
In-Depth Information
stored procedure
@DataFlowTaskName [nvarchar(255)] - contains the name of
the Data Flow Task in which to
to apply the data tap.
@IdentificationString [nvarchar(255)] - contains the
Data Flow Path Identification string
in which to apply the data tap.
@DataTapFileName [nvarchar(4000)] - contains the name of
the file to create to contain
the rows captured from the data tap.
Saved in the <drive>:\Program Files\Microsoft SQL
Server\120\DTS\DataDumps folder.
@DataTapMaxRows [int] - contains the maximum number of
rows to send to the data tap file.
Test:
1. Create and deploy an SSIS Package to the SSIS
Catalog.
2. Exec custom.execute_catalog_package_with_data_tap
and pass it the
following parameters: @FolderName, @ProjectName,
@PackageName,
@DataFlowTaskName, @IdentificationString,
@DataTapFileName,
@ExecutionID Output
@LoggingLevel, @Use32BitRunTime, @ReferenceID,
@ObjectType,
and @DataTapMaxRows are optional and defaulted
parameters.
Example:
Declare @ExecId bigint
Exec custom.execute_catalog_package_with_data_tap
'SSISConfig2014','SSISConfig2014','Child1.dtsx',
'Data Flow Task', 'OLESRC Temperature.OLE DB Source
Output',
'Child1_DataFlowTask_OLESRCTemperature_OLEDBSourceOutput.csv',@ExecId
Search WWH ::




Custom Search