Hi Brian!

I already did it many times - change field type to char and try to retrieve that strange values. But as I see control simply do not passing in...

Hi jwiner and Brian!

I finally found out what going on. In DBase5 table the field value was not Null! In Visual DBase it represented as " / 0/ ...

Thank You Brian!

I allow Null for destination field in SQL table and use code You gave, but DTS still convert only first records from DBase, where source field not Null....

Yes, i did it. Both of them - define default value for SQL server table and uncheck "Allow Null" checkbox. But result the same. DTS stop with error when try...

Yes, jwiner, I tried it.

In DTS I created two connections - DBase5 and SQL Server, Connect them with "Add Transform" arrow, and in Properties of that transformation (tab "Transformations")...