SSIS 2012 XML Source: System.ArgumentException: Value does not fall within the expected range.

• waralees

  SSC Eights!

  Points: 862

  More actions

  September 25, 2013 at 2:23 am

  #283628

  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.

• Jim Squires

  SSC Rookie

  Points: 25

  More actions

  July 11, 2016 at 8:30 am

  #1889425

  Did you ever find the answer to this? I'm having the same issue.