Simple really, remove all the guff for the testing and you're left with the update statement. The update statement refers to a table variable that was created for testing, so...

"...I actually don't need this data in the database at all:..."

That's just the data I used to test the query and make sure it works. See the comment, 

"-- create...

I'd also revisit the database/table design. It seems like you're trying to achieve two outcomes in one hit,

1) provide quick insert/delete response 24x7

2) hold 200gb of data for decision support and analysis

In...

Ahhh ... even bigger jump this time ...

"...I was referring to the updating of the 'Asgnmnt' table..."

In that case you don't need...

"...except that with the actual updating of the table..."

Hmmm ... are you referring to updating your Asgnmnt table, or the table variable that you created?

Can you post the...

Before removing BUILTIN\Adminstrators, make sure you have another login that has sysadmin rights otherwise you'll lose sysadmin access to the server.

Take a look at the article over here http://www.sqldts.com/default.aspx?200

This is for text files, but the Excel connection works the same. Just replace the part that reads '("Text File (Source)")'...

If you're logging to SQL Server you can use the sp_dump_dtspackagelog stored procedure in the msdb database to remove package log. It accepts a package name, package id, package version id...

What server are you running this on? How are you creating the CDO Message?

SQL Agent tokens are only relevant for SQL Agent Alerts. Also, I think you're complicating things using...

If the the email is arriving with a corupted attachment it could well be the email server. We had some problems with Exchange 2000 not using the correct encoding nad...

Easiest method I can think of would be to set something like the application name in the DSN-Less connection. This will show up in sysprocesses as the Program Name. Then you...

Is the destination going to be SQL Server? If so, then your best bet would be to load the data into a staging table in the SQL Server database. Then...

Mike, you can add columns to a table in Enterprise Manager without too much fuss at all. Just add them at the end. Then EM will just use the sp_addcolumn...

Jon "...done the same with yours..." & podatum "...perhaps phillcart's own forum..."

If you're referring to http://www.sqlserver.org.au as my forum/portal then you're mistaken. Australian SQL Server User Groups is a general...

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...