DTS Runs ok but Varchars are Fixed Length?? 1

[hegartyjp]

I have a DTS package to bring data from Oracle to SQL Server.

The package first creates the table using for most fields a type of Varchar(20).

Then it populates the table with data.

The problem is they are coming in sort of as fixed length values.

If a string is 5 chars long, it puts 15 white spaces after it.

Can anyone tell me why this is.

Would really appreciate it. This DTS thing is all new to me.

Thank you....

 

[gradley]

It is probably how Oracle is passing the value.

Try using a TRIM on the Source field prior to inserting into the destination. You can do this with an ActiveX transform script.