TARGIT Enumeration Task is a custom component for SQL Server Integration Services. The component assists in creating and maintaining simple lookup tables for lists of integer or string values.
The Enumeration task can contain lists of key/value pairs for values not otherwise available, making it easier to add or change values than having to maintain hardcoded lists in SQL scripts. Each list of key/value pairs is created as a separate table in the database. The table is dropped and re-created every time the task runs.
The TARGIT Enumeration component is included in the "TARGIT Custom SSIS Tasks" installation package found in the TARGIT App & Gauge Store or the Download Center on the TARGIT Portal. After installation, a restart of SQL Server Data Tools and the SSIS project is required for the task(s) to appear in the SSIS toolbox.
Right click the listbox on the left and select Add. A new element called New Enumeration appears. To complete the new item list, assign a useful name and the name of the table to be created. Finally, select whether the key for the item pairs is a number (integer) or a string (nvarchar). Complete the new list by adding as many item pairs as desired.
After running the task, each list definition results in a separate table of value pairs in the SQL Server database.
|
Related articles appear here based on the labels you select. Click to edit the macro and add or change labels.
|