VBA Rubberducking

Duga

12:00 AM

RELOAD!

[rubberduck-vba/Rubberduck] 3 issue comments.

[Minesweeper] New Users: 20, Games Played: 175, Bombs Used: 113, Moves Performed: 20395

Quack Exchange

8:35 AM

0

Q: pivotfield.orientation = xlhidden does not work

I have a vba code which checks all the pivots in specified worksheets to add a range of pivotfield to the values/data section of the pivot because the pivot headers change every 4 weeks. I have 6 pivots where this code works perfectly, but 2 pivots where I keep getting an error. I have tried t...

vba

FreeMan

10:57 AM

@KySoto in the call to EXEC [SSISDB].[catalog].[create_execution] one of the parameters is @reference_id=@environment_id where @environment_id is set based on a parameter passed to the sproc.

Son Goku ssj4

11:10 AM

:-D Well. It's one of the most complicated languages. For example
1 finger ... prst
2 fingers ... prsty
3 fingers ... prsty
4 fingers ... prsty
5++ fingers ... prstů

It depends on what "family" is the word derived. We've got 3 family trees
1 - Male ... Pán (mister), Hrad (castle), Muž (man), Stroj (machine)
2 - Female ... Žena (woman), Růže (rose), Píseň (song), Kost (bone)
3 - Middle ... Město (city), Moře (sea), Kuře (chicken), Stavení (building site)

And each of them have 7 cases depending in which contex you speak of them, like:

@Hosch250 I'm not sure to be honest... But for most cases it depens on the first five numbers... 1-5, then it's the same word as the 5th. :)

FreeMan

@SonGokussj4 O_o

Son Goku ssj4

Okay, so I noticed that we've got only 3 types of plural.
1
2-4
5
:-)

FreeMan

Dude, seriously, so many Americans screw up English and we don't have any word genders, most of us wouldn't stand a chance!

Son Goku ssj4

11:31 AM

@FreeMan ( ͡ᵔ ͜ʖ ͡ᵔ )

FreeMan

OK, I've just gone from the old-skool, original smilies :-) (or shortcut to :)) to the "newer class" O_o. Don't be throwing all that extra newfangled... Arabic? text based smilie stuff at me!

#OneStepAtATime

Son Goku ssj4

I was using this -> ^_^ <- since Ragnarok Online 1 :-D Man that's too long. I have certifications for using more advanced stuff now :-D

FreeMan

I was using :-) with Compuserve when 2400 baud was the new hawtness

wow I had no idea. You gotta stand waaay back and cross your eyes to make sense outta some of those.

ლ(ಠ益ಠ)ლ

Son Goku ssj4

( ͡° ʖ̯ ͡°)

FreeMan

11:49 AM

Someone said it out loud! And on Academia.SE, even!!

2

A: Are athletes' college degrees discounted by employers and graduate school admissions?

Speaking from the perspective of hiring in industry, I've neither asked for nor considered GPA as a factor when evaluating a resume. The reputation of the school plays a small role (commercial for-profit schools, in particular, warrant further scrutiny), but mostly for an entry level position I'...

FreeMan

12:28 PM

DBA.SE to the rescue

7

Q: SSIS 2012: The environment reference n is not associated with the project

I have a package that I am updating. The package is executed by a Job Agent job. After deleting the package and then deploying the new version, I run a script that executes any necessary [create_environment], [create_environment_reference], [create_environment_variable], and [set_object_parameter...

ssis-2012

seems I'd failed to add my 2nd environment to the package. The Mar '16 answer indicates that the assignment can get lost when redeploying the package, but I'll bet I forgot to add it in the first place.

Now, unfortunately, my sproc doesn't seem to work at all when directed against my Prod environment. I wonder if there's something hardcoded into the package that's pointing to dev and it's not picking up the 'Prod' server assignment somewhere...

FreeMan

12:42 PM

Yeah, I think that's the problem. My connection manager:

My Prod environment specifies that should should be Reporting instead of ReportingDev. How do I parameterize that?

had it "parameterized" to a fixed value. That's not so good...

Hosch250

1:27 PM

Don't you put your DB name in the connection string?

FreeMan

well... I've been messing with that.

At first I thought I needed just the DB name and that didn't work. Then I tried putting in the full connection string, and that doesn't seem to be working either.

and now, one of my connections seems to have the ConnectByProxy parameter set and I don't seem to be able to unset it.

carp - Initial Catalog is what I want. The connection to the server remains static, it's the database on that server that's changing.

I'd seen Initial Catalog when I was setting it up, but that didn't register with Database, which was the only term I knew at that point.

FreeMan

2:13 PM

@FreeMan you "unset" an environment variable by expanding Expressions in the connection property and deleting the value for the variable you want to delete. When you leave that field, you get a warning that it will be deleted and click OK.

#Intuitive

KySoto

@FreeMan i wasnt talking about in your procedure call, i mean IN the ssis package

oh further reading in the thread says you didnt actually associate your production environment with your package

le derp

FreeMan

@KySoto I did, just not properly.

51 mins ago, by FreeMan

At first I thought I needed just the DB name and that didn't work. Then I tried putting in the full connection string, and that doesn't seem to be working either.

49 mins ago, by FreeMan

carp - Initial Catalog is what I want. The connection to the server remains static, it's the database on that server that's changing.

KySoto

2:28 PM

Alrighty

so it looks like you figured it out hten?

FreeMan

getting there.

seems I failed to create an sproc in production that I'm using... Got that sorted, continuing testing in prod

^deployment procedures could use a spiffing up...

Changed the default parameter value in SSIS & it ran in prod! now to test it via the sproc call

FreeMan

2:52 PM

YEEEEEEEEEEESSSSSSSSSSSSSSSSSSSS!!!!!111!!1!!1!1OnE!!!!

success

and it works at the same level in Prod as it does in Dev.

IvenBach

Well that’s good.

FreeMan

Still needs some post-load reporting work, but I'm most satisfied with the progress so far.

and just in time, since I have to get the report to mah boss today!

BIG thanks again to @this and @MathieuGuindon for the guidance and questions answered, and @all for the various random questions, suggestions & nudges in the right direction and the overall support & encouragement!

KySoto

3:10 PM

if i need to do line replacement on a module

do i need to have the VBIDE reference checked?

Mathieu Guindon

3:23 PM

@FunThomas - its a downside to VBA that you can't overload functions. That's basically how you'd handle this in any other langague. :-/ — ArcherBird 13 mins ago

love that I was able to masterfully parry this attack on VBA

I mean, I'll take the reputation :-D. This is off topic so I'll probably remove this comment in a second, but just want to say thank you for Rubberduck. I use it literally every day! — ArcherBird 16 secs ago

♥

IvenBach

4:56 PM

You're developing a dedicated trail of duckling behind you with RD.

IvenBach

5:15 PM

I had to ask myself why string interpolation doesn't work in VBA. I then realized it's what I was asking...

Mathieu Guindon

5:49 PM

lol

Transcript for