Local window shows empty Variables while debugging SSIS package in VS Data tools 2012
This has been bothering me for a long time. I am unable to debug SSIS package efficiently because the Variables collection of SSIS package is always empty.
SS of Locals window showing blank value for Variables collection variable
Updated after userfl89 gave an alternative solution
Also, the watch window is showing unable to evaluate the expression error message
I found a similar issue in general VS development environments (C#, VB.NET) and tried suggestions/answers. For example, changing Debug->Options->Debugging-> check Managed c++ compatibility mode (see ss below) but it did not work for me.
SS of debugging setting:
I have also tried to run in both 64bit mode and 32bit mode, but this also did not work. However, I can see variable values inside script task written in C# code. It has become a painful task to debug packages. Please someone help.
Environment:
Windows 7 Enterprise (64bit)
Visual studio 2012 for Data Tools (version 11.0.6xxx)
.Net Framework 4.6
visual-studio-2012 ssis visual-studio-debugging sql-server-2012-datatools
edited Nov 20 '18 at 17:45
Thronk
4551131
asked Nov 14 '18 at 15:57
Solow DeveloperSolow Developer
94911343
add a comment |
This has been bothering me for a long time. I am unable to debug SSIS package efficiently because the Variables collection of SSIS package is always empty.
SS of Locals window showing blank value for Variables collection variable
Updated after userfl89 gave an alternative solution
Also, the watch window is showing unable to evaluate the expression error message
I found a similar issue in general VS development environments (C#, VB.NET) and tried suggestions/answers. For example, changing Debug->Options->Debugging-> check Managed c++ compatibility mode (see ss below) but it did not work for me.
SS of debugging setting:
I have also tried to run in both 64bit mode and 32bit mode, but this also did not work. However, I can see variable values inside script task written in C# code. It has become a painful task to debug packages. Please someone help.
Environment:
Windows 7 Enterprise (64bit)
Visual studio 2012 for Data Tools (version 11.0.6xxx)
.Net Framework 4.6
visual-studio-2012 ssis visual-studio-debugging sql-server-2012-datatools
edited Nov 20 '18 at 17:45
Thronk
4551131
asked Nov 14 '18 at 15:57
Solow DeveloperSolow Developer
94911343
add a comment |
This has been bothering me for a long time. I am unable to debug SSIS package efficiently because the Variables collection of SSIS package is always empty.
SS of Locals window showing blank value for Variables collection variable
Updated after userfl89 gave an alternative solution
Also, the watch window is showing unable to evaluate the expression error message
I found a similar issue in general VS development environments (C#, VB.NET) and tried suggestions/answers. For example, changing Debug->Options->Debugging-> check Managed c++ compatibility mode (see ss below) but it did not work for me.
SS of debugging setting:
I have also tried to run in both 64bit mode and 32bit mode, but this also did not work. However, I can see variable values inside script task written in C# code. It has become a painful task to debug packages. Please someone help.
Environment:
Windows 7 Enterprise (64bit)
Visual studio 2012 for Data Tools (version 11.0.6xxx)
.Net Framework 4.6
visual-studio-2012 ssis visual-studio-debugging sql-server-2012-datatools
edited Nov 20 '18 at 17:45
Thronk
4551131
asked Nov 14 '18 at 15:57
Solow DeveloperSolow Developer
94911343
This has been bothering me for a long time. I am unable to debug SSIS package efficiently because the Variables collection of SSIS package is always empty.
SS of Locals window showing blank value for Variables collection variable
Updated after userfl89 gave an alternative solution
Also, the watch window is showing unable to evaluate the expression error message
I found a similar issue in general VS development environments (C#, VB.NET) and tried suggestions/answers. For example, changing Debug->Options->Debugging-> check Managed c++ compatibility mode (see ss below) but it did not work for me.
SS of debugging setting:
I have also tried to run in both 64bit mode and 32bit mode, but this also did not work. However, I can see variable values inside script task written in C# code. It has become a painful task to debug packages. Please someone help.
Environment:
Windows 7 Enterprise (64bit)
Visual studio 2012 for Data Tools (version 11.0.6xxx)
.Net Framework 4.6
visual-studio-2012 ssis visual-studio-debugging sql-server-2012-datatools
visual-studio-2012 ssis visual-studio-debugging sql-server-2012-datatools
edited Nov 20 '18 at 17:45
Thronk
4551131
asked Nov 14 '18 at 15:57
Solow DeveloperSolow Developer
94911343
edited Nov 20 '18 at 17:45
Thronk
4551131
asked Nov 14 '18 at 15:57
Solow DeveloperSolow Developer
94911343
edited Nov 20 '18 at 17:45
Thronk
4551131
edited Nov 20 '18 at 17:45
Thronk
4551131
edited Nov 20 '18 at 17:45
Thronk
4551131
4551131
asked Nov 14 '18 at 15:57
Solow DeveloperSolow Developer
94911343
asked Nov 14 '18 at 15:57
Solow DeveloperSolow Developer
94911343
asked Nov 14 '18 at 15:57
Solow DeveloperSolow Developer
94911343
94911343
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I'm assuming that you already set a breakpoint? When the package hits the breakpoint, on the top menu go to Debug > Windows > Locals and from here expand the top variables node, however it looks like you've already done this. You can also view the variables values in the Watch windows by typing the name of the variable in the Name field when the breakpoint is reached. This will only be the variable name, not the @[User::Variable] syntax.
answered Nov 14 '18 at 16:24
userfl89userfl89
2,4141511
This is alternative solution not actual solution. The main issue is the collection variable is always blank. Anyway, thanks for useful tip for not to use SSIS variable syntax in watch window.
– Solow Developer
Nov 15 '18 at 9:39
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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%2f53304187%2flocal-window-shows-empty-variables-while-debugging-ssis-package-in-vs-data-tools%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I'm assuming that you already set a breakpoint? When the package hits the breakpoint, on the top menu go to Debug > Windows > Locals and from here expand the top variables node, however it looks like you've already done this. You can also view the variables values in the Watch windows by typing the name of the variable in the Name field when the breakpoint is reached. This will only be the variable name, not the @[User::Variable] syntax.
answered Nov 14 '18 at 16:24
userfl89userfl89
2,4141511
This is alternative solution not actual solution. The main issue is the collection variable is always blank. Anyway, thanks for useful tip for not to use SSIS variable syntax in watch window.
– Solow Developer
Nov 15 '18 at 9:39
add a comment |
I'm assuming that you already set a breakpoint? When the package hits the breakpoint, on the top menu go to Debug > Windows > Locals and from here expand the top variables node, however it looks like you've already done this. You can also view the variables values in the Watch windows by typing the name of the variable in the Name field when the breakpoint is reached. This will only be the variable name, not the @[User::Variable] syntax.
answered Nov 14 '18 at 16:24
userfl89userfl89
2,4141511
This is alternative solution not actual solution. The main issue is the collection variable is always blank. Anyway, thanks for useful tip for not to use SSIS variable syntax in watch window.
– Solow Developer
Nov 15 '18 at 9:39
add a comment |
I'm assuming that you already set a breakpoint? When the package hits the breakpoint, on the top menu go to Debug > Windows > Locals and from here expand the top variables node, however it looks like you've already done this. You can also view the variables values in the Watch windows by typing the name of the variable in the Name field when the breakpoint is reached. This will only be the variable name, not the @[User::Variable] syntax.
answered Nov 14 '18 at 16:24
userfl89userfl89
2,4141511
I'm assuming that you already set a breakpoint? When the package hits the breakpoint, on the top menu go to Debug > Windows > Locals and from here expand the top variables node, however it looks like you've already done this. You can also view the variables values in the Watch windows by typing the name of the variable in the Name field when the breakpoint is reached. This will only be the variable name, not the @[User::Variable] syntax.
answered Nov 14 '18 at 16:24
userfl89userfl89
2,4141511
answered Nov 14 '18 at 16:24
userfl89userfl89
2,4141511
answered Nov 14 '18 at 16:24
userfl89userfl89
2,4141511
answered Nov 14 '18 at 16:24
userfl89userfl89
2,4141511
2,4141511
This is alternative solution not actual solution. The main issue is the collection variable is always blank. Anyway, thanks for useful tip for not to use SSIS variable syntax in watch window.
– Solow Developer
Nov 15 '18 at 9:39
add a comment |
This is alternative solution not actual solution. The main issue is the collection variable is always blank. Anyway, thanks for useful tip for not to use SSIS variable syntax in watch window.
– Solow Developer
Nov 15 '18 at 9:39
This is alternative solution not actual solution. The main issue is the collection variable is always blank. Anyway, thanks for useful tip for not to use SSIS variable syntax in watch window.
– Solow Developer
Nov 15 '18 at 9:39
This is alternative solution not actual solution. The main issue is the collection variable is always blank. Anyway, thanks for useful tip for not to use SSIS variable syntax in watch window.
– Solow Developer
Nov 15 '18 at 9:39
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.
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%2f53304187%2flocal-window-shows-empty-variables-while-debugging-ssis-package-in-vs-data-tools%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
