The way you've got it typed up above, it looks like you're trying to parse the string directly in the SQLStatement. That doesn't work. You either have to use the...

You may want to take a look at some of the options outlined here. It shows how to use parameters in the query. Of course, if you really just...

For quick info, searches on Yahoo (used to be Google). For slightly longer research times, books, postings here, blogs.  For even longer term learning, books & conferences.

Microsoft actually publishes...

I'm beginning to the think the software has failed. I can't seem to post a reply to this topic properly.

The error is in how the proc is called. If you...

I found the difference. I'm calling the procedure differently. You're using the TSQL standard of '? = EXEC proc' instead of '{? = CALL proc}'

I found out why that's a...

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