May 1, 2025 at 5:51 pm
I have a production SSIS package that is on a SQL 2008 R2 instance, and looking at the package using Visual Studio 2008 (installed on the server), I can look at the Variables window and NOT be able to see it. BUT... I can see it listed when I go to modify the expression for any given variable that I can see, and thus I was able to find the value of it simply by creating a brand new variable, and assigning this variable as the expression for its value... the question is why I can't find it in the list of Variables until I edit the expression for any other variable, and then a BIDS HELPER window opens, and then I can find that variable in the list in the BIDS HELPER window. At that point, I can select it and then choose Edit the expression, but all I really get to do there is modify the value, as I don't get an expression editor... I get a popup window with the value.
So.... I tried upgrading the package to work with SQL2019 and on my Visual Studio 2019 Community Edition and having it become part of an SSIS Project. It wasn't easy, as none of the connections would work until I changed the provider to OLE DB Driver for SQL Server. Then one of the script component tasks wasn't editable, and another script task somehow got metadata messed up. I suspect that going that many versions of upgrade is the problem, but I still can't see any of the system variables in the package in the variables window, which VS2019 no longer allows you to see. So I have a number of these variables that are all in the "Template" namespace, and I am wondering what my best course of action for finding out if they actually have expressions or can only be fixed values, might be.
Anyone?
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
May 1, 2025 at 7:04 pm
I figured it out... I had gotten very used to looking at VS 2019 and when I looked again at VS 2008, I found that variable from the "Template" namespace listed without showing the namespace portion, and sure enough, that is in the variables window in VS 2019 as well...
This gettin' old crap ain't for sissies...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply