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

I have the same question (0)

All responses (4)

Answers (0)

Ragnar Hilmarsson 3,427 on at

Like (0)

Report

Can you share your field map for Kingsway Dynamics components

Was this reply helpful? Yes No
Suggested answer

Marco.P 2,405 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Johao Larios 1,795 on at

Like (0)

Report

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

Was this reply helpful? Yes No
KingswaySoft 545 on at

Like (0)

Report

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.

Was this reply helpful? Yes No