OK, I guess it is working. Perhaps the trace doesn't show the contents of the variable @addy above. The e-mail went through which would seem to indicate the...

OK, here's the syntax I have:

sp_get_admin_email:

CREATE PROCEDURE [dbo].[sp_get_admin_email] (@address VARCHAR(100) OUTPUT)

AS

SELECT @address = Admin_email from tblSettings

GO

sp_mail_test:

CREATE PROCEDURE [dbo].[sp_mail_test]

@bodyfile VARCHAR(8000), @subj VARCHAR(8000)

AS

declare @rc int

declare @addy VARCHAR(100)

EXEC [dbo].[sp_get_admin_email] @addy OUTPUT

exec @rc =...

Any chance you could give a quick example of the proper syntax?

Here is the crux of my sp_get_admin_email:

SELECT Admin_email FROM tblSettings

I've tried something along these lines, but it still isn't...

Yeah, I always get tripped up on that alias syntax using DELETE.

I'm not sure I understand this code:

DELETE FROM tblARData As ar

WHERE EXISTS (

SELECT *

FROM DataDate_md As md

WHERE md.Site = ar.Site

)

"DataDate_md" - that's not a...

Thanks. That parsed fine. Just sloppy editing on my part.

Yes, that typo did exist (now fixed), but I get a similar error message with the last line now:

"Incorrect syntax near the keyword 'INNER'."

OK, I think I understand your INSERT statement. I've put the code in, but have yet to test. At least it parses correctly.

As for the UPDATE statement, here...

Question - on the INSERT INTO statement, do the two records for Vendor 999 get picked up in the subquery? And if so, does this cause a problem when...

AAAAAHHHHHH!!!!!

Thanks so much. Actually, it wasn't the (-1) vs. (True) that was tripping me up, it was omitting the test of the value of global variable "foundUNICODEFiles" as an...

OK, done. New testing Destination table (using same VBScript transformation code above) gets NULLs in every column when the file is processed. As before, if I do a...

Thanks. That fixed it.