how is data streamed in sql server 2005

I want to know how is data stream transfered when i transfer data from one server to other server using client machine (client tools).

When i execute DTS package, is data streamed through client machine to destination as in SQL 2000.

I know in SQL 2000 to run DTS package on server side without streaming from client machine was to run DTS package as sql agent job on server.

Please confirm if this has changed in SQL 2005.

All other tools like AbInitio ETL tool executes on server side.

We were evaluation SQL 2005 for our future projects.

Please confirm.

The package executes on the machine from which it is called.

-Jamie