Sure. Did you get a zip program which accepts DOS command lines?

Have you created the table to hold the data from the CSV file? You will also need to create...

I don't have the code at my fingertips, but I know how to approach the problem (sounds like a job interview, right?).

You can cycle through the collection of DTS packages,...

Here's the Outlook part. Put this in the ThisOutlookSession class (open Outlook, hit Alt-F11, hit Ctrl-R, expand Microsoft Outlook Objects, open ThisOutlookSession).

This reviews your inbox every time a message...

There might be a few ways to structure this. Off the cuff, it seems that you might do well to do some Outlook Automation inside of Outlook first (using VBA...

Stan, you say:

"To conclude...the code for selecting the records I am more than happy with...the problem I have is that the output is in many 'recordsets' and I only...

there is even a view of databases: INFORMATION_SCHEMA.SCHEMAS

You can do the same thing using the INFORMATION_SCHEMA VIEW. The syntax would be:

SELECT CATALOG_NAME

FROM INFORMATION_SCHEMA.SCHEMATA

Supposedly the system tables could change in a future release of SQL Server, but the...