134 Dynamic Variables Implementation in SQL Server Integration Services Available to Purchase

The purpose of presenting the paper is to highlight the benefits derived from implementing concept of dynamic variables in SQL Server Integration Services (SSIS) and how it has indirectly helped reduce number of SQL databases, Tidal Scheduler Jobs, SSIS packages, reduce redundancy and most importantly reduction of headcount effort. The paper highlights issues encountered by process due to redundancy of architectural design leading to duplicity of asset components and how issue was resolved by implementing architectural reengineering by removing hard coding of values and implementing dynamic referencing.