This will not work on SQL Server 2005 and the definition did not specify capabiity with SQL Server 2005 and.or 2008

But, I am still on SSIS 2005 with no plans to advance to SSIS 2008. Is there any workaround to this problem?

I am doing the exact same thing, but no errors or no data in destination or no data to view in data viewers. What is the issue?

I started with SQL (Oracle 5.0) in 1989 and got hooked quickly. I am amazed with the new VERBS and methods you can now do, but for the most...

This executes. I executed on a SQL Server 2005 database server with 5 databases and all "user" databases where changed to "sa".:-)

Worked Perfect !!!

This is resolved now, I found the problem. Since our database was case sensitive, I was having issues with tempdb.information_schema.columns. So I changed them to upper case...

No, the order of the columns even after adding the "order by" clause are still being displayed in alpha order. Anybody have any ideas

I tried it and it failed:

exec sun_sp_send_mailhtml

'OUTBOUND.SMTP.USI.NET', --SMTP Server

'chemapptabware@sunocoinc.com', --From

'TabWareRTCheck@sunocoinc.com', --To

'', --CC

'', --CCi

'NOTICE: RT TabWare - Missing GL Transactions', --Subject

'select plant, convert(varchar, transaction_date,110) transaction_date, transaction_type

from NEV_TW_PROD.dbo.in_log_material

where...

My HMTL body output is getting cut-off and now showing all the content:

Anybody know why?

Thanks, I will try that.

What about in the message body, I see this first before the columns:

<td

What is this and how do I get rid of it

where? in the SQL I pass or in the stored procedure

This stored procedure is great, but I still see one flaw. When passing the SQL, the output always sorts the columns in alpha order on output not the order...

Cannot see all the images and information. Please re-post;-)