Skip to Main Content
ASME Press Select Proceedings

International Conference on Mechanical Engineering and Technology (ICMET-London 2011)

Editor
Garry Lee
Garry Lee
Information Engineering Research Institute
Search for other works by this author on:
ISBN:
9780791859896
No. of Pages:
906
Publisher:
ASME Press
Publication date:
2011

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.

Abstract
Keywords
Introduction
Challenges
Competitive Approaches
The Suggested Solution Framework
Solution Architecture — Ssis
Analysis of Suggested Solution
Current Status
Conclusion
Acknowledgment
References
This content is only available via PDF.
Close Modal
This Feature Is Available To Subscribers Only

Sign In or Create an Account

Close Modal
Close Modal