Sadly, this seems to be true. I cannot find any reference, in BOL, forums, or the SQL Server Management Studio to doing T-SQL stored procedure debugging. That's a really bad...

In Management Stuido, Open SQL Server Agent, then Jobs, and click on jobs.

Right click on the pane, and 'create new job'. Give it s good, descriptive name and preferably a...

Hmm - interesting. Have you got a link or reference for those problems?

When you say you put the XML into a variable, what do you mean? An SSIS variable? If so, what type - string? when you say 'nothing happens' - what...

some progress:

following my google sarch, I found this article/blog:

http://www.julian-kuiters.id.au/article.php/ssis-execute-sql-task-output-parameters

and after reading it, I changed my invocation from:

Connection Type: OLE DB

to

Connection Type: ADO.NET

This allows me to give real names...

Thanks Jamie,

Off I go to play then. I'll check that link as well. Cheers

@jamie: That's an interesting suggestion. How do you get more infomration - is there more put into the default logging, or is that information available to store in...

I realize this was posted a long time ago - please forgive me for digging it up, but it is one of the few matches I've had while trying to...

PS: Your 'Help from Aunt Kathi' Link seems to be broken....

I found my problem - I had specified that the SP returns RESULTSET of SINGLE ROW - whereas I needed to say that RESULTSET was NONE.

The following page gave me...

The answer to this is to user CTRL+ENTER when getting to the end of the annotation object's width, rather than ENTER, or trying to look for a setting, or trying...

I'll be interested to hear more about this, and whether it is an issue, since I'm likely to have similar issues once my current piece of work get's out of...

just to confirm that the copy and delete does work, although it copies directory and sub-sir, and that doesn't seem configurable. I'm noticing that there seems to be quite a...

Just a note/warning. All that wonderful code out there that uses undocumented stored procedures (like sp_msforeachdb) and makes use of system tables (like sysobjects) are likely to have problems when...

NP Hope it helps