Check this out: http://blogs.technet.com/swi/archive/2008/05/29/sql-injection-attack.aspx

Instead of @P1, use ?, then click on the Parameters button and when Parameter Mapping dialog displays, map P1 to Parameter1.

Thanks for taking the time to explain this, Jeff. It was very helpful.

Good post, Jeff. It is posts like this that makes daily watching of this forum worthwhile.

I used this script 2 years ago and it gave me a little trouble, but you can work with it. I apologize that I did not save the author's name,...

I was looking for something like this a few years ago. What I really wanted to do was to parse the result not necessarily change it and put it back...

The code project has a whole lot of scripting help

http://www.codeproject.com/

I refer to W3 Schools continually. It has a LOT of scripting help.

http://www.w3schools.com/

Nigel Rivett's script has been a big help for us. We have been using it for a couple of years and it is very, very good.

http://www.nigelrivett.net/ScriptDTSProperties.html

I also found...

Question for rbarryyoung: if you recompile everything, how can you insure that the children are recompiled before the parents. If the parents are recompiled first, say, because they are recompiled...

Excellent article!

Will put to use immediately!

BTW, in the sentence "I have found them particularly handy when cleaning up demoralized tables. ",

did you mean "I have found them particularly handy when...

For a freebie, look into

http://www.sqldts.com/242.aspx

here's a start:

http://jamesmccaffrey.spaces.live.com/blog/cns!504C7CC53E7E7FE8!135.entry

http://www.androidchinese.com/article.cfm/id/149165

My take on this is that you seem to be the one burdened for the process to work right, so you do it. Become the defacto dba. Take the time,...