ETL and Data Integration tools - Modern ETL software for everyone

I want to populate a MSSQL identity field automatically. I have not been successful in doing this with VIMP Pro v7.0.4.

- I am using MS SQL Server, not the ODBC connection.
- I have an identity field in the table structure.
- I have the field marked as "Not Mapped" and tried both "Keep Identity" as True and False.

In addition, I tried field types of int and numeric in the MSSQL table structure.

The message I get from VIMP Pro is "Mandatory Field LOANID missing", (LOANID is my identity field)

Please Email us the following
table creation script.
example of data
Error Log
VImpRepository.mdb file

Mike

Hi.

I've managed to reproduce the problem

Can you try the following

set Keep Identity to false
set Mapping type to calculated for identity field
type 1 in calculation box

Mike

Your solution works, thank you.

set Keep Identity to false
set Mapping type to calculated for identity field
type 1 in calculation box