The only way that I know to do this is to use xml.  You create a stored procedure that receives a text parameter.  Then using OpenXML you can insert all...

In the Workflow properties, you can execute an ActiveX script that determines whether to run the step or not.  The task called "MyExcelTask" (use your name; find name in the disconnected...

Fair is not the word I would use.  I just have never seen anything in it for me and my organization.

I think that the one who will most suffer by this decision is Microsoft.  This will add one more reason not to upgrade to Vista.  Currently Vista is working at...

Thanks for the article.  As a developer who makes my money on the Microsoft platform, it totally annoys me that Microsoft, in its total arrogance, shooting itself in the foot. ...

I personally prefer multiple ways to send feed back.  I can understand that a better structured web page response would be more easily processed and therefore more likely to impact...

I had trouble.  It asked for a paid subscription to see the article.

Try putting at the end of the routine the following line (assuming that you have assigned the connection to conTarget):

msgbox conTarget.DataSource

Does the datasource change as you expect?

Remove this code from...

I really can't say for sure without looking at your code.

You might be looping on one value, but actually setting the connection to the first value every time.  You might be setting...

The process of SPID 2 has a lock of some type that prevents the blocked SPID from completing its work.

Can you posta copy of the code in your Begin Loop and Loop Around scripts?

Russ

I couldn't believe what you were saying until I tried it.  My only guess is that the collection cannot handle a variant (all variables in VBScript are variant, not string...

Enjoy these moments.  SQL Server 2005 will morph to SQL Server 2020 and the kid is going to wish that you were not around (and definitely not a geek).

There are...

Still think we need to figure out how to harness the energy of 8 year old boys.

Russ

Would there be some way to put a COM wrapper around the assembly and use com in your stored procedure?

Russ