Hi,

I'm using the Kingswaysoft SSIS integration to import and update records in Salesforce. One step imports Opportunities and links them to exisitng Accounts and Contacts (we have Person Accounts).

However, some records fail with the dreaded INVALID_FIELD_FOR_INSERT_UPDATE error on ContactId. I can't work out why this happens, because many similar records in the same batch pass and are imported correctly with the Contact link.

I would appreciate some help identifying what the cause could be so I can fix it to always work for all reords.

Thanks

I'm currently using a SOQL Object Query as part of an SSIS package and I need the data sorted for the next step in my SSIS data flow.

However, SOQLs "Order by" does not produce the sort order that SSIS expects and uses internally. For example, the list:

aa
ab
a-b
ac

Comes out like this with a SOQL Order By, which uses ASCII sorting:

a-b
aa
ab
ac

But SSIS is expecting the list like this, as it uses Windows Collation:

aa
a-b
ab
ac

Is there any way to force the SOQL Order By to use Windows Collation instead of its default? Is there any workaround in SOQL to get the list sorted how I want?

And yes I know I can use SSIS Sort Transformations, but I'm trying to avoid them because they're clunky and expensive. I can use them as a last resort, but I'd prefer the data sorted at source.

Hi,

I'm using the Kingswaysoft SSIS integration to import and update records in Salesforce. One step imports Opportunities and links them to exisitng Accounts and Contacts (we have Person Accounts).

However, some records fail with the dreaded INVALID_FIELD_FOR_INSERT_UPDATE error on ContactId. I can't work out why this happens, because many similar records in the same batch pass and are imported correctly with the Contact link.

I would appreciate some help identifying what the cause could be so I can fix it to always work for all reords.

Thanks

I'm currently using a SOQL Object Query as part of an SSIS package and I need the data sorted for the next step in my SSIS data flow.

However, SOQLs "Order by" does not produce the sort order that SSIS expects and uses internally. For example, the list:

aa
ab
a-b
ac

Comes out like this with a SOQL Order By, which uses ASCII sorting:

a-b
aa
ab
ac

But SSIS is expecting the list like this, as it uses Windows Collation:

aa
a-b
ab
ac

Is there any way to force the SOQL Order By to use Windows Collation instead of its default? Is there any workaround in SOQL to get the list sorted how I want?

And yes I know I can use SSIS Sort Transformations, but I'm trying to avoid them because they're clunky and expensive. I can use them as a last resort, but I'd prefer the data sorted at source.