Hmm ... I may be missing something here but I don't see where there is an issue with the code sample you've provided. For both the select statements I get

-----------...

Ok, you can still capture some of the DTS output by specifying an output file on the advanced tab of the job step.

Edit the DTS package and turn on package logging.

Then after the package is executed you can view the log by right clicking the package -> Package Logs...

You're probably in the Management Studio, try the Development Studio.

For SQL 2000, if the default parameter entry doesn't meet your needs the only option is to build a custom front-end for parameter input.

Following on from Steve and PW's suggestions, I'd definately re-organise the query to remove the SELECT from the case and place it in to the FROM clause

Basically your criteria can be...

Haven't done this myself, but try copying the dtproperties table across to the new database. This is where the meta-data for the diagram is stored.

You'd be looking for,

ALTER TABLE myTable ALTER COLUMN myGuid

 DROP ROWGUIDCOL

A quick Google for this error would solve your problem,

http://support.microsoft.com/default.aspx/kb/315886

Fair bit of basic reasearch that you can do,

http://www.microsoft.com/sql/prodinfo/overview/what-is-sql-server.mspx

http://msdn.microsoft.com/sql/downloads/samples/default.aspx

No problemo, we've all been there ...

and probably

http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx

Well as this is more of an SQL Server site than a Visual C++ site, I'd suggest you take a look at,

http://msdn.microsoft.com/vstudio/express/visualc/learning/default.aspx

Are you referring to the syntax for creating the table?

If so, take a look at this,

http://msdn2.microsoft.com/en-us/library/ms178078.aspx

Or you could just use Reporting Services which has email delivery built-in