Where is the above error?

Could you find the Append output file ... checkbox and uncheck it in your DTS package?

Did you try to use Database Mail?

You have to wait for the driver, I believe.

Did you try to use triggers?

Where did you fire your command? Did you set the environmental variable?

Did you try to change

'consultant.consultant'

to b.consultant

?

I am not sure whether or not I understand your question correctly. If I do, you may try,

SELECT a.*, b.* FROM TableA a CROSS JOIN TableB b

Your description is opposite to my experiences. Did you check whether or not there are any other tasks running against this server?

If my understanding is correct, you do not need to drop the foreign key. I just tested it.

Did you have change to read the following article? You may need a newer ODBC driver based on this article.

http://support.microsoft.com/kb/q158618/

Other possible approaches

Make sure you have cleanly removed previous replication;

Restart your...

Did you try something like below? It is a user-defined logevent when the number is greater than 50000.

Master..xp_logevent 55000, '…'

It is a security issue. You need to check the login info in your package. By the way, I think you had better post this question to SQL 2005 column.

Steve Jones - Editor (7/8/2008)

---

You can't do this, because the drivers for OLEDB/ODBC will use the logged on credentials.

Most OS's now allow a "switch user", which logs in a 2nd...

As far as I understand, it is an issue that we would like to have either abig horse (powerful CPU) to pull a small cart (memory,load) or a small horse...