Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SSIS 2012 XML Source: System.ArgumentException: Value does not fall within the expected range. Expand / Collapse
Posted Wednesday, September 25, 2013 2:23 AM


Group: General Forum Members
Last Login: Monday, August 4, 2014 7:58 PM
Points: 24, Visits: 128
Dear All,

I'm newbie for SSIS. I use XML source to get data to MSSQL DB. I have test to run in my this package, it's pass. BUT

1. When the other package to call XML transform package via "Execute Package Task", It's fail.

2. I try to run XML transform package on server. It's fail.

Error Messages are the same

[XML Source [1271]] Error: System.ArgumentException: Value does not fall within the expected range.
at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSBufferManager100.FindColumnByLineageID(Int32 hBufferType, Int32 nLineageID)
at Microsoft.SqlServer.Dts.Pipeline.DtsDataTable.SetupColumns(DtsDataTableCollection dtsDataTableCollection, IDTSOutput100 output, Int32 localeID, IDTSBufferManager100 bufferManager)
at Microsoft.SqlServer.Dts.Pipeline.DtsDataTableCollection.AssociateTablesWithBuffers(IDTSOutputCollection100 outputs, IDTSBufferManager100 bufferManager, Int32 localeID, DataSet dataSet)
at Microsoft.SqlServer.Dts.Pipeline.XmlSourceAdapter.PreExecute()
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)

[SSIS.Pipeline] Error: XML Source failed the pre-execute phase and returned error code 0x80070057.

Any one can help me?

Thanks in advance.
Post #1498189
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse