ETL and Data Integration tools - Modern ETL software for everyone

Hello

I am running Visual Importer Enterprise

I have a field in a SQL table that is set to Tinyint.

When I do an import using csv files, the data in the csv file is set to 5 or 9 or any other number.

When it gets imported its set to Zero “0”.

If it is on a foreign key, it will reject out due to zero not being
in the other table.

I am using SQL Server 2005.

Tim

Tim.

I have run several tests and could not find anything wrong with it.

If you wish I can connect remotely am check.

Mike

Yea sure if you could take a look.

Let me know when you have a chance and I will setup the connection quick.

Tim

Tim

We have reproduced and fixed the problem in house

Can you please download the latest version and let us know the outcome

Mike

Yes, it works!

Thank you for the prompt reply

Tim