duanecwilson
Programmer
Cannot show visual studio for applications editor. The variable cannot be found.
There seems to be many posts on this topic that even suggest uninstalling and reinstalling Visual Studio or other extreme ideas only to find out that after all the effort, the package still didn't work.
I got this error because my variable names were not consistent in one or two places and my only solution seemed to be to edit the code directly (dtsx file) and make sure my variable names were consistent including matching case. The one that got me was intBadRows and intBadrows. When I made them all consistent in code view, I saved the package and restarted it and it worked fine. But I had gone through quite a bit before I got to this point.
All that said, I am fairly new to SSIS, and find it very difficult and quirky to use, but I am slowly finding my way. Maybe someone else has gotten this error as well, and can provide some more tips about it.
Duane Wilson
There seems to be many posts on this topic that even suggest uninstalling and reinstalling Visual Studio or other extreme ideas only to find out that after all the effort, the package still didn't work.
I got this error because my variable names were not consistent in one or two places and my only solution seemed to be to edit the code directly (dtsx file) and make sure my variable names were consistent including matching case. The one that got me was intBadRows and intBadrows. When I made them all consistent in code view, I saved the package and restarted it and it worked fine. But I had gone through quite a bit before I got to this point.
All that said, I am fairly new to SSIS, and find it very difficult and quirky to use, but I am slowly finding my way. Maybe someone else has gotten this error as well, and can provide some more tips about it.
Duane Wilson