Thursday, January 31, 2013

SSIS pass a child package varaible value to the parent package

Introduction

my project has two package , one is child package , the other is parent package , that means in the parent package , the child package will be executed , below is data flow screen shot , in the child package , i created a variable called child_row_count , which will assign row count number

 
next is parent package , which will execute the child package , and send the child_row_count variable's value to me by email , note that there need create another variable called parent in parent package
 
next step is create script in child package , which was used to assign child package variable "child_row_count" to parent package variable "parent"
 
 
1 setup the ReadOnlyVariables and ReadWriteVariables
note that ReadWriteVariables should be parent package variable , but they are not in the list , you have to manually type in without "User:: "
 
 
2 script
 
Dts.Variables(
"parent").Value = Dts.Variables("child_row_count").Value

if you want to pass the parent package variable to child , you also can use this approach



 


No comments:

Post a Comment