HI, I have a confusion....
Its logical that all objects must be in a same sever(database,dts,stored
procedures,views,etc) but what happends when all objects fight for the
resources. I hear that its good to have the DTS and the databases in different servers, one sever for databases and one server for DTS.

I need your advice.