I haven't worked with it yet, but I just finished reading about the new managed code interface. The new class name is Microsoft.SqlServer.Dts.Runtime. It has an encapsulated class called Package....

Take a look at the Stealth Collector from Quest. It basically uses Profiler data to create the exact kind of aggregates & drill down you're looking for.

It would be nice...

Here's the info we recieved from Microsoft:

Based off the case that we had opened with MS, the best recommendation we have from PSS is to monitor MTL using "DBCC...

Holy Cats! We just ran into MemToLeave issues to. I had no idea what a limit there was on the servers due to memory management prior to hitting that problem.

I...

I can't believe you've got me working in Access to try this out, but here goes...

I did it by simply converting the data for both columns to a string, then...

I'm no Oracle expert, but I thought that was set in the TNSNAMES file.

We've been using Quest Stealth Collector to get aggregate information out of Profiler data on the fly and with history. If there was a way to make this tool more...

Just a guess, but when I used the configuration wizard, it stored the Oracle password as "******" instead of the actual value. When I edited that to an actual password...

Despite having had the ability to cascade delete for years, I haven't set it up, not one single time. It is too scary and completely out of control. At the...

Cascading deletes are a different requirement than that if a parent is deleted, so must the children. The question is one of automated actions vs. intentional actions. With DRI in...

There's a nice little task that was created for just this purpose at SQLIS.com (http://www.sqlis.com/default.aspx?23). I've used, not in production yet, and it works very well.

There are also some decent little samples out at SQLIS.com

Not an Integration Services question, but... You get a new error log each time SQL Server is restarted. However, in order to keep the size of the logs smaller, you...

I'd report this one to Microsoft.

I tried, but I can't replicate the behavior. Any other clues?

And so, your code is flawless, always. And the next guy who writes some code against your system, he too doesn't need data integrity checks because his code is perfect....