The content of any regular or manual transformation can be stored in a table, typically to improve access speed for complex transformations. Persisting the transformation is managed through an SSIS package.

To persist a transformation, the user should select "Add → Persisting" from the object context menu in the diagram.

As shown in the image below:

Persisting Wizard Options

As shown in the image below:

• Transformation: The name of the transformation to persist.
• Persist Table: The name of the table where the transformation will be persisted. This table will be created in the same schema as the transformation.
• Persist Package: The name of the SSIS package that manages the persistence process.