I think the problem here is that you're circumventing the backup/restore process by copying the mdf and ldf files directly. XCOPY is not a backup tool, otherwise it would be...

Nice article, but you forgot to mention one trick, or should I say chore Refresh, refresh, refresh and if you still can't find...

Ahhh .... Ok, progressing in leaps and bounds now ... in that case you should do the update.

SET NOCOUNT ON

-------------------------
-- create and populate testing source table
DECLARE @Asgnmnt TABLE(CallID...

Check the paragraph headed "Temporary Tables" in the description for CREATE TABLE in Books Online. If this doesn't clarify things then submit another post explaining what you don't understand.

Let me just get past the reson you would want to do this as temp tables are created uniquely for the connection anyway.

I think your problem is to do with...

What is returned for just the select portion?

SELECT CallID, GroupName

    ,  CASE

           WHEN GroupName = 'SD Followup' then 'Y'

           ELSE 'N'

        END as CustPendCase

FROM Asgnmnt

Hmmm ... don't know if I'd want to support a community that doesn't use the technology ...

I don't think you actually need the update part. You can include your CASE in the SELECT,

DECLARE @table TABLE(CallID VARCHAR(8), GroupName VARCHAR(15), CustPendCase VARCHAR(1)) 
INSERT @table(CallID, GroupName, CustPendCase) 
SELECT...

This script resides in an ActiveXScript task that executes before your datapump. You set this up using the workflow. I've always found this article to be a good example of...

I presuming you, restarted the services after changing the option

You might even need a full server reboot...

Also, take a look at this article,

http://www.sql-server-performance.com/awe_memory.asp

"...with the data found in the actual tables..."

So you would need to reference those table in the FROM clause.

EG:

INSERT @table(CallID, GroupName, CustPendCase) 
SELECT CallID, GroupName, NULL
FROM <your table...

What edition of SQL Server are you running?

Using DTS to drop and re-create the tables is not the approach you should be taking here.

If you can't perform delete/update/insert statements to update the destination tables, then a...

"INSERT @table(Asgnmnt.CallID, Asgnmnt.GroupName, CustPendCase)

 SELECT CallID, GroupName, NULL UNION ALL

SELECT CallID, GroupName, CustPendCase FROM @table"

For the highlighted statement, there is no FROM clause so where are the columns coming...