Thanks for the GREAT help.

The script was PERFECT.

Thanks for the info.

Thanks

It works . . .

Yes, that is what I am trying to accomplish.

Please post some sample code if possible.

It does not have to be perfect, just something to get me started.

Thanks for your help...

  1. Setup c:\template\1st_report.xls

     Format it to be landscape, gray headers, etc

     Increase column widths to avoid getting an error in step #8

       ** You can also setup two tabs...

Thanks.

Here is the final code if anyone needs it.

objMail.TextBody = "Total is " & DTSGlobalVariables("OIW_DOLLAR").value

Related Links:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_addf_misc_68tv.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_dts_task_6llt.asp

http://www.google.com/search?q=Global+Variable+sql+activex&hl=en&lr=

I found out how to get the output into a global variable, and tested some theories to make the below work, however I cannot seem to get it to work.

Can...

text of StoredProc

yes, would like to see all case variations

That worked great.

Thanks for the info.

Thanks for the info.

Sorry about the cross-post.

I will stop doing double posting.

You can also do the following if you don't want to setup Reporting Serivces:

1. create the "formatted" report in networkdrive/templates/reportname.xls

2. setup a DTS job that will take transfer the file...

It still fails

Please reply

That worked good.

Thanks for the info.

That worked good.

Thanks for the help.

Related Question:

How can you backup transaction logs onto tape and delete logs weekly so your hard drive does not get full ?