SQL Server - Bulk Load

[alchemiz]

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

[alchemiz]

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