web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / KingswaySoft - Impossi...
Microsoft Dynamics CRM (Archived)

KingswaySoft - Impossible to run SSIS package on SQL Server

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

I have an SSIS package who run perfectly on my local machine.

When i try to run it on SQL Servor I have the following error on my XML Source component :

Import réservations etesting:Erreur : System.ArgumentException: La valeur n'est pas comprise dans la plage attendue.
   à Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSBufferManager100.FindColumnByLineageID(Int32 hBufferType, Int32 nLineageID)
   à KingswaySoft.IntegrationToolkit.ProductivityPack.XmlSourceComponent.rcf.ogm(IDTSOutputColumn100 mgd, IDTSExternalMetadataColumn100 mge)
   à System.Linq.Enumerable.<JoinIterator>d__38`4.MoveNext()
   à System.Linq.Buffer`1..ctor(IEnumerable`1 source)
   à System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
   à KingswaySoft.IntegrationToolkit.ProductivityPack.XmlSourceComponent.nsr()
   à KingswaySoft.IntegrationToolkit.ProductivityPack.XmlSourceComponent.PreExecute()
   à Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)

Thakns for helping me

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    KingswaySoft Profile Picture
    KingswaySoft 545 on at

    Hello Cecile,

    For the error “Value does not fall within the expected range” error, it seems to be an issue caused by the SSIS optimization design, it happens when you don’t have all the output attached to a destination component.

    In this case, either of the following two options can solve the issue properly:

    • Set the RunInOptimizedMode property to False in the Properties window at Data Flow Level . This setting can be found after you click the blank area on your data flow designer.
    • Alternatively, you can try to direct other outputs of the XML Source component to a SSIS Destination component which can take care of this situation as well.

    Please let us know if there is anything else.

    Thank you,

    KingswaySoft

    support@kingswaysoft.com

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans