Just change the name of the parameter to '0' (no quotes).

Check here from the BOL:http://msdn2.microsoft.com/en-us/library/ms141003.aspx

That was an outstanding article. Thanks.

We're currently in a bit of a struggle with a development team that has become completely enamored with generated code. Problem is, with type of...

Thanks for the pointer. We're pretty committed to sticking with Integration Services, replacing DTS, and from what I saw on the web site this is a seperate tool, not an...

You need to look in the "Progress" tab if the package is running or in the "Execution Results" tab if the project has stopped. Scroll up on the screen, above...

Never mind. I am a dope.

Just in case there are one or two more people as stupid as I (or worse, more stupid), SQL doesn't support Smart Indents, but it...

This worked:

"C:\\Documents and Settings\\fritcheyg\\My Documents\\Visual Studio 2005\\Projects\\SSIS\\Chapter6\\test_" +   (DT_WSTR,2)DATEPART("Hh",GETDATE()) + (DT_WSTR,2)DATEPART("mi",GETDATE()) + ".txt"

That's set in the ConnectionString property.

The classes exposed by Microsoft.SqlServer.Dts.Runtime should do the trick. There are samples in ASP & C# in the Wrox book (http://www.amazon.com/gp/product/0764584359/sr=8-1/qid=1140525802/ref=pd_bbs_1/002-4538442-1224846?%5Fencoding=UTF8)

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...

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...