Customer experience | Sales, Customer Insights,...

SSIS Kingsway Soft Help

(0) Share

Report

Posted on by sunnz

Hi there, I have an SSIS package running on an sql server and receiving the following error message:

An error occurred with the following error message: "System.ArugmentException: Value does not fall within the expected range. (SSIS Integration Toolkit for Microsoft Dynamics 365)

I was wondering if anyone had insight on this.

Thanks in advance

All responses (4)

Answers (0)

KingswaySoft 545 on at

Like (0)

Report

RE: SSIS Kingsway Soft Help

You can reach out to our Support team with screenshots of the design as well as the CRM component you are using. We can definitely take a look at it.
Suggested answer

Johao Larios 1,795 on at

Like (0)

Report

RE: SSIS Kingsway Soft Help

Hello,

This could mean that you are trying to import a value of an option set that is not in you target system. Please validate that if you are passing option set data, they should match, please take a look on this: docs.microsoft.com/.../create-edit-global-option-sets I think that you have a correct label but not a correct value for those guys that are failing

Also, take a look on the kingswaysoft information for option sets: www.kingswaysoft.com/.../optionset-mapping
Suggested answer

Marco.P 2,405 on at

Like (0)

Report

RE: SSIS Kingsway Soft Help

It seems that you are setting an option set field with a value that does bit exist. If i were you, i'd check that ( and also build an error handler to get the row that failed)

Hope it helps,

Marco
Ragnar Hilmarsson 3,427 on at

Like (0)

Report

RE: SSIS Kingsway Soft Help

Can you share your field map for Kingsway Dynamics components