Microsoft SSIS rules

Include Folders Filter: Specify specific folders to include in current rule.

Include Projects Filter: Specify specific projects to include in current rule.

Include Packages Filter: Specify specific packages to include in current rule.

Exclude Filter: Specify specific keywords used to exclude Folders/Projects/Packages.

Unmapped data source category: Choose from the categories created in Categories or create a new category via the built-in sub-menu.

Unmapped file source category: Choose from the categories created in Categories or create a new category via the built-in sub-menu.

Data source Category: Will hold Tasks and Components that interact with any source of data.

Destination Category: Will hold Tasks and Components that interact with any destination of data.

Show transformations visually: When enabled, NodeGraph will show any underlying transformation steps performed in components between a data source and destination.

Transformation Category: Only visible when “Show transformations visually” is enabled. Will hold Tasks and Components transformation data.

Include filters are treated with a logical AND. For example, if a site and project filter is used, only the matching projects within the matching sites are included. If an include filter is left empty, all matches will be included. All filters can be typed as specific strings or as wildcard patterns. If multiple filters are wanted, they can be separated by a semicolon.

Add an SSIS rule
Field	Default Input
SELECT RULE TYPE	SSIS rule
NAME	Enter a name for this rule
DESCRIPTION	Description (optional)
INCLUDE FOLDERS FILTER	ETL; Extract; Transform
INCLUDE PROJECTS FILTER	ETL; Extract; Transform
INCLUDE PACKAGES FILTER	ETL; Extract; Transform
EXCLUDE FILTER	Archive; Test*
UNMAPPED DATA SOURCE CATEGORY	Select category or add new
UNMAPPED FILE SOURCE CATEGORY	Select category or add new
DATA SOURCE CATEGORY	Select category or add new
DESTINATION CATEGORY	Select category or add new
TRANSFORMATIONS CATEGORY	Select category or add new
RULE PRIORITY	Enter a processing priority for this rule

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here