Viewing 15 posts - 22,096 through 22,110 (of 22,197 total)
Check out Solid Quality Learning (solidqualitylearning.com). We've scheduled an inhouse class with them in April, so I can't report on the specifics of their SSIS course. However, we've used them...
February 21, 2006 at 5:46 am
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....
February 21, 2006 at 5:38 am
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...
February 20, 2006 at 6:41 am
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...
February 17, 2006 at 11:48 am
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...
February 17, 2006 at 11:46 am
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...
February 17, 2006 at 11:04 am
I'm no Oracle expert, but I thought that was set in the TNSNAMES file.
February 17, 2006 at 6:11 am
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...
February 17, 2006 at 5:37 am
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...
February 15, 2006 at 7:57 am
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...
February 15, 2006 at 5:28 am
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...
February 14, 2006 at 9:54 am
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.
February 14, 2006 at 9:33 am
There are also some decent little samples out at SQLIS.com
February 14, 2006 at 9:29 am
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...
February 14, 2006 at 9:07 am
I'd report this one to Microsoft.
I tried, but I can't replicate the behavior. Any other clues?
February 14, 2006 at 6:52 am
Viewing 15 posts - 22,096 through 22,110 (of 22,197 total)