Henry,

Here's a way to do the first part of the question using a join and making sure you don't overwrite OldEmail with a NULL as Sushila just pointed out:

UPDATE A

Set...

You are getting a "Disk or Network Error". You might want to check for file existance before the transform.

Try an ActiveX Script Task before the transform. You can...

You need to "Refresh Fields" after you finish entering the EXEC statement. It's a little icon next to the dataset dropdown. If done properly, you will get a...

Correction:

Maybe this is a scope or session problem.

Since the execute sql task basically puts a "GO" after each sql statement, try to put a semicolon after your insert command:

INSERT INTO...

Maybe this is a scope or session problem.

Since the execute sql task basically puts a "GO" after each sql statement, try to put a semicolon after your insert...

Don't forget the semicolons:

DECLARE @DateParm DATETIME;

SELECT @DateParm = ?;

select *

from tableA a

where exists (Select ID

from tableB b

where b.ID = A.ID

and b.Date = @DateParm )