SSIS how to duplicate variable to multiple containers
up vote
0
down vote
favorite
I have an SSIS Solution that works dynamically.
it looks like this:
I have a Foreach loop container that runs on files in a folder,
inside the Foreach loop container, I have lots of containers, and inside the containers, I have a lot of dynamic variables. (please look pic attached My Solution)
My question is,
How I build A new variable and duplicate him in all the containers? (the variables needs to be in the container scope)
Thanks,
Ben
ssis
asked Nov 21 at 10:14
Benzi
12
add a comment |
up vote
0
down vote
favorite
I have an SSIS Solution that works dynamically.
it looks like this:
I have a Foreach loop container that runs on files in a folder,
inside the Foreach loop container, I have lots of containers, and inside the containers, I have a lot of dynamic variables. (please look pic attached My Solution)
My question is,
How I build A new variable and duplicate him in all the containers? (the variables needs to be in the container scope)
Thanks,
Ben
ssis
asked Nov 21 at 10:14
Benzi
12
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have an SSIS Solution that works dynamically.
it looks like this:
I have a Foreach loop container that runs on files in a folder,
inside the Foreach loop container, I have lots of containers, and inside the containers, I have a lot of dynamic variables. (please look pic attached My Solution)
My question is,
How I build A new variable and duplicate him in all the containers? (the variables needs to be in the container scope)
Thanks,
Ben
ssis
asked Nov 21 at 10:14
Benzi
12
I have an SSIS Solution that works dynamically.
it looks like this:
I have a Foreach loop container that runs on files in a folder,
inside the Foreach loop container, I have lots of containers, and inside the containers, I have a lot of dynamic variables. (please look pic attached My Solution)
My question is,
How I build A new variable and duplicate him in all the containers? (the variables needs to be in the container scope)
Thanks,
Ben
ssis
ssis
asked Nov 21 at 10:14
Benzi
12
asked Nov 21 at 10:14
Benzi
12
asked Nov 21 at 10:14
Benzi
12
asked Nov 21 at 10:14
Benzi
12
asked Nov 21 at 10:14
Benzi
12
12
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
After you create the variable you can change the scope of it by clicking the Move Variable button (second button from the left, in the variables window of your screenshot) and then selecting the executable that you want to scope it to. Keep it mind then when there are multiple variables with the same name, the component will first check its immediate scope then move upwards until the first variable with the corresponding name is found.
answered Nov 21 at 14:23
userfl89
1,06659
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
After you create the variable you can change the scope of it by clicking the Move Variable button (second button from the left, in the variables window of your screenshot) and then selecting the executable that you want to scope it to. Keep it mind then when there are multiple variables with the same name, the component will first check its immediate scope then move upwards until the first variable with the corresponding name is found.
answered Nov 21 at 14:23
userfl89
1,06659
add a comment |
up vote
0
down vote
After you create the variable you can change the scope of it by clicking the Move Variable button (second button from the left, in the variables window of your screenshot) and then selecting the executable that you want to scope it to. Keep it mind then when there are multiple variables with the same name, the component will first check its immediate scope then move upwards until the first variable with the corresponding name is found.
answered Nov 21 at 14:23
userfl89
1,06659
add a comment |
up vote
0
down vote
up vote
0
down vote
After you create the variable you can change the scope of it by clicking the Move Variable button (second button from the left, in the variables window of your screenshot) and then selecting the executable that you want to scope it to. Keep it mind then when there are multiple variables with the same name, the component will first check its immediate scope then move upwards until the first variable with the corresponding name is found.
answered Nov 21 at 14:23
userfl89
1,06659
After you create the variable you can change the scope of it by clicking the Move Variable button (second button from the left, in the variables window of your screenshot) and then selecting the executable that you want to scope it to. Keep it mind then when there are multiple variables with the same name, the component will first check its immediate scope then move upwards until the first variable with the corresponding name is found.
answered Nov 21 at 14:23
userfl89
1,06659
answered Nov 21 at 14:23
userfl89
1,06659
answered Nov 21 at 14:23
userfl89
1,06659
answered Nov 21 at 14:23
userfl89
1,06659
1,06659
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53409765%2fssis-how-to-duplicate-variable-to-multiple-containers%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
