[/quote]

if you are using ODBC connection in the Dts Chack It On The sql Server Machine and Try To run the dts from the DTS designer On The Server Machine

...