DTS Trimming My Data

Hi

I have a DTS package that pulls data from oracle and inserts it into SQL.
During this transfer, any data that has trailing spaces, loses those spaces
in SQL. i.e. it's been trimmed.

Any way to set DTS not to trim the data ?

Thanks

SteveHi

This may be due to the ANSI_PADDING setting being OFF

http://msdn.microsoft.com/library/d...asp?frame=true

John

"Steve Thorpe" <stephenthorpe@.nospam.hotmail.com> wrote in message
news:bj4qt9$752$1@.titan.btinternet.com...
> Hi
> I have a DTS package that pulls data from oracle and inserts it into SQL.
> During this transfer, any data that has trailing spaces, loses those
spaces
> in SQL. i.e. it's been trimmed.
> Any way to set DTS not to trim the data ?
> Thanks
> Steve