To add to the recommendation to remove it, the SCD component in SSIS (at least in 05 and 08) is a piece of crap. The Inserts are fine. ...

Brandie Tarvin (8/15/2014)

---

It's Wednesday. 3 people walk up to your cube. One is from the QA team, one is from the reporting team, and one is a business user. The...

Adam,

I have a similar concern for one of my packages. I approached this differently, however. I use a SQL Server Configuration Table and have a parameter which...

We don't typically pre-estimate growth and the like in a justification document, but as a DB Dev we do write ALL scripts for the DBAs to run. There's a...

You can. I do it to replace the XML, which you can't pass.

SQLRNNR (8/14/2014)

---

Ed Wagner (8/14/2014)

---

Evil Kraig F (8/14/2014)

---

djj (8/14/2014)

---

Wish I could remember what last year was like, I remember some nice days for '77 as I have a...

john.brees (8/14/2014)

---

Hello, I would be grateful if anyone could help me. I have to modify an SSIS package that someone else has written that prompts the user for a variable...

djj (8/14/2014)

---

Wish I could remember what last year was like, I remember some nice days for '77 as I have a picture of me from a company...

By chance is that information set by configuration?

Just an additional note on this: Any seriously competent sysadmin with physical access to the box, unless it has no interfaces (USB, CD Roms, etc), can bypass just about...

Yes, they can. They...

Anything you turn off on a sysadmin, they can turn back on. Any restriction you give them they can remove. That's the point of being a sysadmin. It's...

sleipner (8/13/2014)

---

As I mentioned a while back - I deal with extremely large ad-hoc reports that often have LOTS of null values in them. When you're trying to do...

Damnit, double post, sorry.

Need a sample of the information in #t (aka, some row inserts), and your code doesn't match your table. But yeah, need to see what's in the table that's...