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
"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