Brenda

xp_smtp_sendmail has a parameter called @MessageFile, You just pass in the full path and filename to the html file and it is used as the message body. There is quite...

So what is the completed Query string look like? Are you able to copy it into Query Analyzer and run it?

syslogins is a view on sysxlogins. In the view, the password field is converted from varbinary to nvarchar.

sysxlogins is an undocumented table, and as such any use is not supported....

Mike

With a MSX/TSX setup, the jobs are copied out to the TSX's. if the MSX is offline the jobs still execute on the TSX they just don't poll for changes.

How are you viewing the syslogins view, via Enterprise Manager or Query Analyzer??

When you say "...it is showing empty...", do you mean it's an empty string or NULL?

If I'm reading you right, you want to pass a value back to the calling package ??

Unfortunately, this is not as obvious as it seems

Or even better get the DTSFTP task from http://www.sqldts.com. This custom task supports both get and put operations unlike the inbuilt FTP task.

Using the # symbols to define date is for MS Access not SQL Server.

Brenda, If you use xp_smtp_sendmail from http://www.sqldev.net it has an option to use a html file as the body of the email. We do this for a couple of...

Anyone had any success at getting to the tech.rssgroup.com website?

I've tried from my work computer and home computer and just get connection timeout errors.

After just resorting to VBScript to create an XML file, I too would love to see the download.

Check Books Online. All the information you need should be in there.

Also, a google search might provide some helpful info.

Try some SQL-DMO scripting.

You also need to be running SQL Server Enterprise Edition.

Standard Edition only supports 2GB RAM.

"WHERE (((CND_CITY Like '%as%') OR (ctry_name Like '%as%') OR (CND_RECENTJOB Like '%as%') OR"

Could it be the extra "OR" on the end of the WHERE clause?