And how can one use this procedure in T-SQL if the [n]text variables aren't supported?

What version of Excel are you using?

For instance, in Excel 2007 in the Data ribbon in the Get External Data section using the "From Other Sources" tool you can create...

Oh, I completely forgot about that one! And to think this was one of the reasons why I moved my temp folder off C:... :hehe:

I see. I think you should verify that the data can be converted in the Script Task, and possibly do the conversion there.

If the source contains rows with variable data...

If all your HTML documents are well-formed XML, you can use the XML data type.

If you plan on using other binary types (doc, pdf, etc.) you should use the varbinary(max)...

Selecting "All databases" in GUI is translated into as many queries/statements as there are databases.

Best way according to what criteria?

In SQL 2000 using a client application to parse XML data is your best option. Don't use SQL Server for tasks it's not good at.

In addition to using DTS you should look up OPENROWSET in Books Online.

However, if the Excel destination is used frequently, you should consider adding a permanent connection to it using...

Your XML did not make it through. Use the IFCode option from the toolbar and repost the example.

You could use the Data Conversion task. Have you considered that?

Look up sp_xml_preparedocument (and sp_xml_removedocument) in Books Online.

In SQL 2000 you're limited to XML instances (i.e. their character representations) not exceeding 8000 Bytes varchar (4000 Bytes nvarchar) as [n]text variables...

Are you aware of the fact that triggers fire *per statement* and *not per row*? Your will get unexpected results for multi-row inserts.

Instead of using the SELECT query (which actually...

Look up PIVOT in Books Online.

Are you using integrated or SQL security?

Do the OS users have access to the server (a SQL Server LOGIN mapped to the Windows NT user account) and the database (database...

You need the appropriate edition of the SP1. AFAIK you have to download it manually from Microsoft Downloads - there are different editions.

OTOH, Microsoft Update is not perfect, and it...