Download sample ssis package update#

Rows Deleted:В Provide a variable name to get count of вЂњDeletedвЂќ rows if you do not collect this data in your logs then select вЂвЂ™.Rows Audited: Provide a variable name to get count of вЂњAuditedвЂќ rows if you do not collect this data in your logs then select вЂвЂ™.Sequence Container:В Provide a sequence container name, it will be used by ETLGen to add data load components.Template Package Path:В Provide template package location, ETLGen will then read the template package to populate Variables and Sequence Containers in their respective drop downs.Template Name:В Provide a name for the template, this name should be unique and will be displayed in the list of available templates in вЂњNew specification DocumentвЂќ page.Provide us with sequence container that can be used for adding ETLGen components and variables to capture row counts such as inserts/updates. Here you will be able to provide location of template package, ETLGen will then automatically get all the sequence containers and variables.

Download sample ssis package update#

New users: Required tables for templates will be created as part of regular installation, please refer to Getting Started page.Д®xisting users: Once ETLGen update has been installed, you will be prompted to run вЂњETLGEN_Logging_DefaultTemplate.sqlвЂќ script which will add new tables to ETLGEN schema. If you would like to see how ETLGen uses SSIS Package template to perform logging, record execution status and dynamic parameter passing, then go to Default Template page. ETLGen adds data flow and control flow tasks inside this sequence container).ДЄlso packages generated by ETLGen can capture row counts such as inserts,updates, can be written into your variables inside the template package. In addition to loading data into tables, there are many instances where we need to perform additional tasks such as logging, updating execution status tables, other company specific tasks, this can be achieved using SSIS Package templates.ДЄdd all the tasks specific to your process and procedures into your SSIS package which will act as template, just add an extra sequence container and ETLGen will add data load components inside this sequence container (i.e.