ETL and Data Integration tools - Modern ETL software for everyone

We are currently evaluating Visual Importer to determine if we can use this as our ETL solution.
I'm having trouble importing data into any SQL Server table that has a UNIQUEIDENTIFER column on the table.
I've tried to set the IDENTITY_INSERT to ON in the Before SQL and then turn it off in the After SQL, but that didn't help.
Can you help me move beyonf this problem?
We're going to buy licenses for the product if we can get it to pass our testing process.

Also, is there any way to import CLOB data from Oracle to SQL Server?

Thanks in advance

Kelley

UNIQUEIDENTIFER field has nothing to do with IDENTITY_INSERT ON

It is completely different field type

I guess your UNIQUEIDENTIFER is a primary key

What you can do is assign default to it by modifying table structure
us newid() as default

or if you are not allowed to modify the table
set mapping type to SQL function and use newid() again

See picture attached

Mike