Script table

The DEPM_MOD_SCRIPT table represents a SQL statement that is used to execute any transformational statement on the staging database.
Name Definition
Name nvarchar(50) NOT NULL; PK
Description nvarchar(150) NULL
ModelName nvarchar(50) NOT NULL; PK
Definition (can contain Custom Settings) ntext NULL
LastSuccessfulExecution timestamp NULL

The name of a script is unique for the model.

LastSuccessfulExecution indicates the time (UTC) when the script was last run with a successful result.

The table has these references:

Source columns Target table Target columns
ModelName _model Name