AnsweredAssumed Answered

Has anyone used the SQL Server bcp connector? finding issues loading data when fields have null values.

Question asked by jason.caruso407553 on Jun 1, 2018
Latest reply on Jun 12, 2018 by jason.caruso407553

I have created a simple process to test out the SQL SERVER bcp connector to bulk loading / unloading from SQL SERVER 2012r2. I have been able to successfully unload/export a couple of tables, but there are other tables that fail in BOOMI because a field value is NULL. I can correct the issue via the DB, but i don't believe that is great path forward. Has anyone else had the same experience and resolved the issue via configuration in boomi?

Outcomes