Package: Set ETL Run Variables Task

The Set ETL Run Variables task runs the following Transact-SQL, which executes a Blackbaud Product Development stored procedure. For more information about stored procedures,see Microsoft's MSDN article at Stored Procedures (Database Engine). The BBDW.USP_ETL_BEGINLOAD stored procedure initializes run variables for ETL.

EXEC BBDW.USP_ETL_BEGINLOAD
@CurrentDataWindowClose =NULL,
@ISPARENT=0,
@SSISPACKAGENAME =?,
@SSISPACKAGEPATH =?,
@SSISSTARTTIME =?,
@SSISUSERNAME=?,
@SSISMACHINENAME =?,
@SSISEXECUTIONINSTANCEGUID=?,
@CLEAR_INCOMPLETE_LOADS=0

The EXEC statement in the example is a parameterized query. For more information about the EXEC statement, see Microsoft's MSDN article at EXECUTE (Transact-SQL). You can manage details about the task with the Execute SQL Task Editor. When you double-click the task, the editor appears. On the Parameter Mapping page of the editor, you can view how parameters (?) in the query are mapped to variables. Most are system variables. One variable, ETLDeploymentFolder, is a string that indicates the location of the ETL deployment folder. ETLDeploymentFolder maps to SSISPACKAGEPATH.

You can view the stored procedure, BBDW.USP_ETL_BEGINLOAD, through SQL Server Management Studio. To view a stored procedure, open SQL Server Management Studio and establish a connection to the stored procedure's database. Then expand the nodes in the Object Explorer as follows: [Database name] > Programmability > Stored Procedures > [Stored procedure name]. Right-click the procedure and click Modify. A query to modify the procedure appears.