Interesting. I've never experienced that. So what code have you written to iterate thru all databases?

What bug did you find in sp_msforeachdb?

Only Microsoft can answer that question:-)

Not really. Many undocumented procedures work fine and are really useful.

Check out this article

http://support.microsoft.com/default.aspx?scid=kb;en-us;268520

Then DTS may not be properly installed. Reinstall your client and check.

what is the exact error message you are getting? are you not able to see the task icons in the toolbox in dts designer?

What if you create a dts package with two transform data tasks, one for customerid 2345 with the note field and another for all other customers. Then your excel spreadsheets...

Check out this article

http://www.sqldts.com/?205

How are you setting the value of customerid? Are you trying to write to an existing excel spreadsheet?

can you post your code and the error that you are getting?

write an activex script like

if customer1 then

dtsdestination("col1")=dtssource("col1")

This will only be executed if the global variable matches that customer. There is no need to specify no transformation condition.

What built-in stored procedure can be used to perform the same task for each table in a database?

It would be a good idea to run

DBCC CHECKIDENT (<tablename>, RESEED, 1)

every time before reloading so the identity seed is reset to 1 and you will never reach such...