One problem with returning the xml as a result set is that it is truncated at 2033 characters I believe. (not sure if that is the exact number) The...

I like the job idea myself. A twist to running a stored proc from a job would be to create a job to send emails using vbscript and the...

I dont remember the exact syntax, but you can call the stored proc you cited above from another stored proc and assign the return value to a variable (as long...

You could also write a batch file to do the FTP tasks and run the batch file from within a DTS using the execute process task(I think this is the...

Thanks for your feedback. Your approach is definitely a solid option. Many ways to skin a cat.

Not sure I understand your example, but there is a function called patindex() that matches patterns with and without wildcards

Thats a big query.

I can't get a great idea of your schema, but at first glance I was thinking that using fulltext indexing might help.

If you...

I know a couple of the tasks allow you to specify the number of retries and the command timeout...is that available in the dynamic properties task or in the task...

check out my article at:

http://www.sqlservercentral.com/columnists/jwiner/forxml.asp

I used sp_webwebtask to do what I think your trying to accomplish.

test

test reply

I think there might be another way to convert the data into xml (although it is a bit unconventional. If the records are hierarchical you can use the shaped...

Are these queries taking minutes to execute? Most queries should only take a second or two tops. Are you running update queries or just selects?

If you set...

I can give you the basics:

Create a function in the Global.asa file to open the connection. Use the ADO connection object to do this.

i.e.

MyFunc

dim cn

set cn =...

You could create and ActiveX script task and use the CDO Message object to send mail. Set the workflow for each task so if they fail, they then go...