SSIS Kingswaysoft error for JSON source
I am using JSON Source component in a package, it is working fine on my local machine but when I deploy in server am receiving the following error.
System.ArgumentException: Value does not fall within the expected range. at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSBufferManager100.FindColumnByLineageID(Int32 hBufferType, Int32 nLineageID) at KingswaySoft.IntegrationToolkit.ProductivityPack.JsonSourceComponent.yhs.cgd(IDTSOutputColumn100 kbk, IDTSExternalMetadataColumn100 kbl) at System.Linq.Enumerable.d__61
4.MoveNext() at System.Linq.Buffer1..ctor(IEnumerable1 source) at System.Linq.Enumerable.ToArray[TSource](IEnumerable1 source) at KingswaySoft.IntegrationToolkit.ProductivityPack.JsonSourceComponent.bdc() at KingswaySoft.IntegrationToolkit.ProductivityPack.JsonSourceComponent.PreExecute() at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)
For the error “Value does not fall within the expected range”, 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 (see figure 1). 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 JSON Source component to an SSIS Destination component which can take care of this situation as well.
Can you please give it a try and see if it helps?
[Figure 1]
- visual studio 2019 open solution file incompatible
- Cannot initialize the data source object of OLE DB provider Microsoft.ACE.OLEDB.12.0 for linked server (null)
- xlsx error: "Removed Records: Named range from /xl/workbook.xml part" when tried to resolve errors
- Getting log messages from an SSIS package executed with an SQL query
- How to preserve data comma ',' while exporting data from SQL Server to flat file (CSV) where column delimiter is ','
- Optimizing OLE DB Destination for Fast load from Oracle to SQL Server for SSIS
- SSIS Package Stuck in "Pending Execution" status
- SSISDB package errs out, says variable does not exist
- SSIS Conditional Split - multiple conditions per output
- Is there any releavance for "ROW PER BATCH" AND "MAX INSERT COMMIT SIZE" IN SSIS PACKAGES?
- data conversion issue while executing a ssis package
- How to generate an Excel file from SQL table using SSIS?
- Empty path name is not legal - DTEXEC with Powershell
- SSIS Error: External Column for Source out of sync with Data Source columns; How do I remove External Columns?
- Error: The type of the value (DBNull) being assigned to variable "User:: differs from the current variable type (String)
- Project consistency check failed. has a different ProtectionLevel than the project
- Could not load file or assembly 'Microsoft.VisualStudio.Tools.Applications.Core, Version=10.0.0.0
- SQL Server Deployed SSIS package won't open files despite SA account having access to folder
- convert Excel Date Serial Number to Regular Date
- SSIS: How to parameterise foreach folder loop location from project.params value?
- Multiple outputs from SSIS Script
- Metadata for multisource in SSIS
- SSIS The expression for variable 'Variable' failed evaluation. There was an error in the expression
- SSIS OLE DB Destination Editor - Create New Table not an option?
- SSIS - Can you use a parameterised query to populate a Lookup Transformation?
- Flattening a Recursive Hierarchy Into a Dimension with SSIS
- SSIS set result set from data flow to variable
- Connection Manager in SSIS task: Keyword not supported: 'ProviderName'
- Passing query results to variable in SSIS
- Controlling the flow in SSIS package based on a condition