1) create a new package and create new package variables
2) right click on the design screen and click Package Configurations
3) On the pop up window, enable package configurations and click Add...
4) click next and change Configuration type to Parent package variable and type a Parent variable
5) on the next screen, expand Variables and variable name(this time "logFileName") and expand its properties and click Value and click Next
6) then click next and you will see a new configuration on the Package Configurations Organizer window
7) repeat this if you have more than one variable to pass from parent to child package.
(In my project, I had to pass 3 variables - LogFileName, TxtFileName, and LogSource)
(In my project, I had to pass 3 variables - LogFileName, TxtFileName, and LogSource)
8) then build this package.
9) go back to parent package and modify Execute Package Task
10) Location can be SQL server or file system depending on where you built your child package.
No comments:
Post a Comment