ETL and Data Integration tools - Modern ETL software for everyone

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

Sorry for not getting back to you sooner.
The new version did fix the issue I was having with the TinyInt.
Thanks again!

Tim