Same DTS execute - differeing results!!!

[PaulSc]

Hi,
I have a DTS routine which carries out a number of tasks

Truncate a table and then Import a text file to a preformatted sql table. there are then follow on steps to split this data etc etc

If I run the DTS from inside Enterprise manager it all works perfectly

If I run it using a DOS DTSRUN command locally it works perfectly

however...

If I execute the script remotely via a PSEXEC call to the original DTS command the script runs but certain fields are being imported onto the database are surrounded by "'s which in turn messes up the follow on tasks as it can't find the fields I'm now looking for..

Anybody have any ideas why this could be happening and any suggested "fix".

Thanks in advance..

 

[PaulSc]

Sorry - running on SQL Server 2000....