Thursday, June 20, 2013

SSIS Parent Package Variables configurations

I had a scenario for executing a package like a stored procedure with different parameters.
I did not want to create multiple copies of the package. so here's my approach.


  1. Create Parameter Variable(s) in the Child Package [note here, the names should be consistent]
  2. Create Parameter Variable(s) in the Parent Package(s) and assign / modify the values in Parent package itself, then simply use a Execute Package Task to execute the child package. nothing else to be configured here. Variable Names and parent package configuration by default takes care of the variable value assignment.
  3. The End.
Made life easy.. 
Cheers
Vivek.



No comments:

Post a Comment