If you're trying to copy a file to a destination, why not use the File System Task? it has a copy function already built in, and avoids you needing to...

Short of seeing any more info, all i can say is, look at your source data flow. Not the actual data flow task for the source, but the connection it...

Try this code. It does the dynamic SQL cross tabs that I had mentioned earlier. I put the date as '1900-01-01' for the records which have a matching responsible-status pair,...

Right, so like Phil said:

replace the PRINT with SELECT

IE:

SELECT 'SQL Server and SQL Server Agent both are running'

Just make sure you have this icon selected. For some reason, it sometimes changes. See attached image for details.

EDIT --- NM, looks like I misunderstood your question.

yeah i'm afraid that i can't help more without seeing the rest. You can feel free to send me the code, just click my name and select send email. Can't...

That's what I've been saying.

Have a table which stores the status of each data flow task. This table has a column that indicates for a given data flow task, whether...

Right, so in each of your data flow tasks, you just need to have a conditional split operator at the start. one half of the split will point towards the...

Why not just do it like this instead:

Have a table that stores a log of each of the 7 data flow tasks for a given day. In this table you...

cross tabs works well for this, especially if you can only have one status/concept pair for a given date and user.

Something like this (can't be more clear without table definitions...

you could do it even simpler probably. just have your trigger execute an HTTP request, and don't bother waiting for the response, since you don't really care about it. just...

if you're suggesting having the trigger execute a stored proc, well, the trigger will then just wait until the stored proc is finished before continuing, so that won't help you...

If you want to have a truly asynchronous process, then yeah, it is. There isn't really any other way of being able to accomplish what you're trying to do.

Yeah - Service Broker is what I'd go with. There are a fair number of tutorials out there in the internet, just google Service Broker Tutorial and you should be...

Excellent! Thanks for the answers!