.png)
sp_helparticledts (Transact-SQL)
Used to get information on the correct custom task names to use when creating a transformation subscription using Microsoft Visual Basic. This stored procedure is executed at the Publisher on the publication database.
Column name | Data type | Description |
|---|---|---|
pre_script_ignore_error_task_name | sysname | Task name for the programming task that occurs before the snapshot data is copied. Program execution should continue if a script error is encountered. |
pre_script_task_name | sysname | Task name for the programming task that occurs before the snapshot data is copied. Program execution halts on error. |
transformation_task_name | sysname | Task name for the programming task when using a Data Driven Query task. |
post_script_ignore_error_task_name | sysname | Task name for the programming task that occurs after the snapshot data is copied. Program execution should continue if a script error is encountered. |
post_script_task_name | sysname | Task name for the programming task that occurs after the snapshot data is copied. Program execution halts on error. |
sp_helparticledts is used in snapshot replication and transactional replication.
There are naming conventions, required by the replication agents, which must be followed when naming tasks in a replication Data Transformation Services (DTS) program. For custom tasks, such as an Execute SQL task, the name is a concatenated string consisting of the article name, a prefix, and an optional part. When writing the code, if you are unsure what the task names should be, the result set gives the task names that should be used.
