I tried the option recompile with no success.

Dynamic SQL...I use it frequently but I don't like to open it up on things that I don't have absolute control of. ...

Originally it was a parameter and it was misbehaving even then.

I didn't think about the dynamic SQL route but that's because I'm mostly opposed to it on principal. 🙂

Anyway,...

All those are incidental at this point. The "good" plan has a fixed value because it's a production stored proc. The bad plan has those differences because I...

Actually, here we go. Find and replace to remove names.

Unfortunately that I cannot do. It would reveal more about my customer than I'm allowed to show.

And it looks like I missed the whole attachments thing. Here we go

To be honest, I had to read it a couple times and go through what I thought I knew before saying anything. 😉

Looking forward to the download.

Found a typo in the Editorial Review:

My book leads you right from the basics of capturing plans, through how to interrupt them in their various forms,...

At a previous job I had luck with a product called "BizCrypto" when it came to SFTP/FTPS in SSIS. It's not free (ranging from about $3k - >$20k depending...

Wish I could claim it as my own. 😎 And wish I could remember where I found it - the guy who did write...

Here's a nice one I use (can't recall where I found it). It'll give you about 2.5 hours worth of history in one minute increments. Run it on...

I've never tried it. In the past I've used a variable that gets used in an expression in the connection in the package.

More recently I've switched to config files....

Enter them on...

RK-383011 (10/10/2008)

---

After opening the solution/project, before opening any package, set the VS to offline mode (SSIS -> Work Offline). Then try opening the packages. I feel that the packages...

Alan Vogan (5/2/2011)

---

Now, instead of acronyms, the industry is using visually appealing terms to sell. I remember when 'BI' came out, I was baffled. Did I miss something? Nope, same...