Forum Discussion

alchemiz's avatar
alchemiz
Contributor III
11 months ago

SQL Server - Bulk Load

Currently I'm having issue when doing a bulk insert where values are set to NULL from field names that doesn't match from the source column names even though column position are the same , e.g Target Table Field name is NotifyCode while Source SP is NotifyId both are in the same column position

I tried renaming the SPs field name to NotifyCode and Target Table Field is now populating

Question: how to set up the SQL Server Bulk Load snap to use ordinal position? Instead of relying to match field names to column names

1 Reply

  • alchemiz's avatar
    alchemiz
    Contributor III
    11 months ago

    Here's a sample, table only has 1 field "Code" and streaming object also has 1 property "Id"
    Doing the bulk insert with 50 streaming docs inserts to table 50 records but field "Code" are set to NULL value