It sounds like you linked up the tasks before you defined the columns to be included. Drop the link between, then set the columns, then reattach the link. It should...

Sorry to say, I'm stumped. I tried replicating it, but I got it seemed to work. I'm just not sure what I'm missing. Sorry.

I haven't done it myself, yet, but it is possible to add a recordset as a variable and then you can pass it around as needed. Here's one article on...

I'd do it in two steps. First, do an update on records where the keys match. Then do a left join with an insert to records where the keys don't...

Oh. That's a bit different. Hmmm... Have you tried debugging it? Stopping on the step that you're running & verifying that the variables are loaded? How about adding logging to...

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