TechBubbles Microsoft Technology BLOG

TagSQL Server 2005

Runtime Settings with SSIS Package

Introduction
Clients may require to integrate the SSIS packages in their environment(Production). SSIS package settings needs to be changed at run time and all settings needs to be pulled from the database using set of stored procedures.
1. Create a SSIS package and drag the Execute SQL task to control flow in the package as follows

TechBubbles Microsoft Technology BLOG

Follow me

Archives

Tag Cloud