SQL Server - Bulk Load

Question

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 · Answer

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&nbsp;

Forum Discussion

SQL Server - Bulk Load

1 Reply

Recent Discussions

Generate expression file from database query

Can we generate XML file in pretty print format using native snapLogic snaps?

401 error with HTTP Client and NTLM

Pagination and nextCursor in header

Javascript to promote top level lists