SSIS XML Source Value does not fall within the expected range
Hi all
I created an ssis package with an for each loop and import of xml source files.
The package runs well in the debugging mode (IDE). The xml source has 5 input ranges, 3 goes in a multicast "recycle bin" the rest is written in tables. When I try to run the package inside an agent job with package configuration the following error appear:
,-1073450910,0x,System.ArgumentException: Value does not fall within the expected range.
More information from the logging:
User:BufferSizeTuning,CHLUZSDB0090,ROOT\SVC_CH_MSSQL,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{D83C0F44-72A5-4737-A484-855FBAA45B73},19.07.2011 12:46:27,19.07.2011 12:46:27,0,0x,Rows in buffer type 0 would cause a buffer size greater than the
configured maximum. There will be only 7532 rows in buffers of this type.
User:BufferSizeTuning,CHLUZSDB0090,ROOT\SVC_CH_MSSQL,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{D83C0F44-72A5-4737-A484-855FBAA45B73},19.07.2011 12:46:27,19.07.2011 12:46:27,0,0x,Rows in buffer type 4 would cause a buffer size greater than the configured
maximum. There will be only 2999 rows in buffers of this type.
OnInformation,CHLUZSDB0090,ROOT\SVC_CH_MSSQL,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{D83C0F44-72A5-4737-A484-855FBAA45B73},19.07.2011 12:46:27,19.07.2011 12:46:27,1074016262,0x,Prepare for Execute phase is beginning.
OnProgress,CHLUZSDB0090,ROOT\SVC_CH_MSSQL,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{D83C0F44-72A5-4737-A484-855FBAA45B73},19.07.2011 12:46:27,19.07.2011 12:46:27,0,0x,Prepare for Execute
OnProgress,CHLUZSDB0090,ROOT\SVC_CH_MSSQL,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{D83C0F44-72A5-4737-A484-855FBAA45B73},19.07.2011 12:46:27,19.07.2011 12:46:27,14,0x,Prepare for Execute
OnProgress,CHLUZSDB0090,ROOT\SVC_CH_MSSQL,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{D83C0F44-72A5-4737-A484-855FBAA45B73},19.07.2011 12:46:27,19.07.2011 12:46:27,28,0x,Prepare for Execute
OnProgress,CHLUZSDB0090,ROOT\SVC_CH_MSSQL,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{D83C0F44-72A5-4737-A484-855FBAA45B73},19.07.2011 12:46:27,19.07.2011 12:46:27,42,0x,Prepare for Execute
OnProgress,CHLUZSDB0090,ROOT\SVC_CH_MSSQL,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{D83C0F44-72A5-4737-A484-855FBAA45B73},19.07.2011 12:46:27,19.07.2011 12:46:27,57,0x,Prepare for Execute
OnProgress,CHLUZSDB0090,ROOT\SVC_CH_MSSQL,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{D83C0F44-72A5-4737-A484-855FBAA45B73},19.07.2011 12:46:27,19.07.2011 12:46:27,71,0x,Prepare for Execute
OnProgress,CHLUZSDB0090,ROOT\SVC_CH_MSSQL,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{D83C0F44-72A5-4737-A484-855FBAA45B73},19.07.2011 12:46:27,19.07.2011 12:46:27,85,0x,Prepare for Execute
OnProgress,CHLUZSDB0090,ROOT\SVC_CH_MSSQL,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{D83C0F44-72A5-4737-A484-855FBAA45B73},19.07.2011 12:46:27,19.07.2011 12:46:27,100,0x,Prepare for Execute
User:PipelineInitialization,CHLUZSDB0090,ROOT\SVC_CH_MSSQL,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{D83C0F44-72A5-4737-A484-855FBAA45B73},19.07.2011 12:46:27,19.07.2011 12:46:27,0,0x,No temporary BLOB data storage locations were provided. The
buffer manager will consider the directories in the TEMP and TMP environment variables.
User:PipelineInitialization,CHLUZSDB0090,ROOT\SVC_CH_MSSQL,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{D83C0F44-72A5-4737-A484-855FBAA45B73},19.07.2011 12:46:27,19.07.2011 12:46:27,0,0x,No temporary buffer storage locations were provided. The buffer
manager will consider the directories in the TEMP and TMP environment variables.
OnInformation,CHLUZSDB0090,ROOT\SVC_CH_MSSQL,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{D83C0F44-72A5-4737-A484-855FBAA45B73},19.07.2011 12:46:27,19.07.2011 12:46:27,1074016263,0x,Pre-Execute phase is beginning.
OnProgress,CHLUZSDB0090,ROOT\SVC_CH_MSSQL,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{D83C0F44-72A5-4737-A484-855FBAA45B73},19.07.2011 12:46:27,19.07.2011 12:46:27,0,0x,Pre-Execute
OnError,CHLUZSDB0090,ROOT\SVC_CH_MSSQL,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{D83C0F44-72A5-4737-A484-855FBAA45B73},19.07.2011 12:46:27,19.07.2011 12:46:27,-1073450910,0x,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(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)
User:PipelineComponentTime,CHLUZSDB0090,ROOT\SVC_CH_MSSQL,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{D83C0F44-72A5-4737-A484-855FBAA45B73},19.07.2011 12:46:27,19.07.2011 12:46:27,0,0x,The component "XML Source" (1) spent 0 milliseconds in PreExecute.
OnError,CHLUZSDB0090,ROOT\SVC_CH_MSSQL,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{D83C0F44-72A5-4737-A484-855FBAA45B73},19.07.2011 12:46:27,19.07.2011 12:46:27,-1073450982,0x,component "XML Source" (1) failed the pre-execute phase and returned error
code 0x80070057.
OnProgress,CHLUZSDB0090,ROOT\SVC_CH_MSSQL,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{D83C0F44-72A5-4737-A484-855FBAA45B73},19.07.2011 12:46:27,19.07.2011 12:46:27,14,0x,Pre-Execute
User:PipelineComponentTime,CHLUZSDB0090,ROOT\SVC_CH_MSSQL,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{D83C0F44-72A5-4737-A484-855FBAA45B73},19.07.2011 12:46:27,19.07.2011 12:46:27,0,0x,The component "Multicast 2" (230) spent 0 milliseconds in ProcessInput.
User:PipelineComponentTime,CHLUZSDB0090,ROOT\SVC_CH_MSSQL,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{D83C0F44-72A5-4737-A484-855FBAA45B73},19.07.2011 12:46:27,19.07.2011 12:46:27,0,0x,The component "Multicast 3" (245) spent 0 milliseconds in ProcessInput.
User:PipelineComponentTime,CHLUZSDB0090,ROOT\SVC_CH_MSSQL,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{D83C0F44-72A5-4737-A484-855FBAA45B73},19.07.2011 12:46:27,19.07.2011 12:46:27,0,0x,The component "Multicast" (365) spent 0 milliseconds in ProcessInput.
The same logging part when it works:
OnWarning,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,-2147192714,0x,The output column "Routing_Id" (2272) on output "RoutingLine" (71) and
component "XML Source" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
OnWarning,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,-2147192714,0x,The output column "Routing_Id" (2289) on output "Routing" (107) and component
"XML Source" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
User:BufferSizeTuning,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,0,0x,Rows in buffer type 0 would cause a buffer size greater than the configured
maximum. There will be only 2236 rows in buffers of this type.
User:BufferSizeTuning,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,0,0x,Rows in buffer type 1 would cause a buffer size greater than the configured
maximum. There will be only 5021 rows in buffers of this type.
User:BufferSizeTuning,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,0,0x,Rows in buffer type 3 would cause a buffer size greater than the configured
maximum. There will be only 7532 rows in buffers of this type.
User:BufferSizeTuning,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,0,0x,Rows in buffer type 7 would cause a buffer size greater than the configured
maximum. There will be only 2999 rows in buffers of this type.
OnInformation,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,1074016262,0x,Prepare for Execute phase is beginning.
OnProgress,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,0,0x,Prepare for Execute
OnProgress,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,10,0x,Prepare for Execute
OnProgress,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,20,0x,Prepare for Execute
OnProgress,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,30,0x,Prepare for Execute
OnProgress,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,40,0x,Prepare for Execute
OnProgress,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,50,0x,Prepare for Execute
OnProgress,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,60,0x,Prepare for Execute
OnProgress,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,70,0x,Prepare for Execute
OnProgress,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,80,0x,Prepare for Execute
OnProgress,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,90,0x,Prepare for Execute
OnProgress,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,100,0x,Prepare for Execute
User:PipelineInitialization,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,0,0x,No temporary BLOB data storage locations were provided. The buffer
manager will consider the directories in the TEMP and TMP environment variables.
User:PipelineInitialization,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,0,0x,No temporary buffer storage locations were provided. The buffer
manager will consider the directories in the TEMP and TMP environment variables.
OnInformation,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,1074016263,0x,Pre-Execute phase is beginning.
OnProgress,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,0,0x,Pre-Execute
User:PipelineComponentTime,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,0,0x,The component "XML Source" (1) spent 0 milliseconds in PreExecute.
OnProgress,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,10,0x,Pre-Execute
User:PipelineComponentTime,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,0,0x,The component "Multicast 2" (230) spent 0 milliseconds in PreExecute.
OnProgress,CHLUZSDB0090,ROOT\dasadmin,Data Flow Task,{CAC354E8-435A-4DF1-BDCF-A7BF0FF56D6F},{FF9DDBAF-2490-4974-9E51-519F8A917C65},19.07.2011 14:34:57,19.07.2011 14:34:57,20,0x,Pre-Execute
Many thanks for your help
Daniel
July 19th, 2011 1:52pm
Hi Arthur
the problem still resist, i was in holiday in the meantime;-)
The following links helps a little bit more with the confusing new CONFIG File strategy from 2008.
http://www.sqlservercentral.com/Forums/Topic781197-391-1.aspx
also helpful:
http://msdn.microsoft.com/en-us/library/ms162810.aspx
I ran the following statement on the cmd prompt (x64 or x86):
DTEXEC.exe /FILE "F:\SSISPackages\Import_TrackTraceXML.dtsx" /CONFIGFILE "F:\SSISPackages\Import_TrackTraceXML_PROD.dtsConfig" /CHECKPOINTING OFF /REPORTING EWCDI
and receive the same error again....
Many thanks for more informations.
BR
Daniel
Microsoft (R) SQL Server Execute Package Utility
Version 10.50.1600.1 for 32-bit
Copyright (C) Microsoft Corporation 2010. All rights reserved.
Started: 13:47:12
Info: 2011-08-16 13:47:14.93
Code: 0x4004300A
Source: Data Flow Task SSIS.Pipeline
Description: Validation phase is beginning.
End Info
Warning: 2011-08-16 13:47:16.33
Code: 0x800470AE
Source: Data Flow Task SSIS.Pipeline
Description: Component "Multicast 2" (230) has been removed from the Data Flo
w task because its output is not used and its inputs either have no side effects
or are not connected to outputs of other components. If the component is requir
ed, then the HasSideEffects property on at least one of its inputs should be set
to true, or its output should be connected to something.
End Warning
Warning: 2011-08-16 13:47:16.33
Code: 0x800470AE
Source: Data Flow Task SSIS.Pipeline
Description: Component "Multicast 3" (245) has been removed from the Data Flo
w task because its output is not used and its inputs either have no side effects
or are not connected to outputs of other components. If the component is requir
ed, then the HasSideEffects property on at least one of its inputs should be set
to true, or its output should be connected to something.
End Warning
Warning: 2011-08-16 13:47:16.33
Code: 0x800470AE
Source: Data Flow Task SSIS.Pipeline
Description: Component "Multicast" (365) has been removed from the Data Flow
task because its output is not used and its inputs either have no side effects o
r are not connected to outputs of other components. If the component is required
, then the HasSideEffects property on at least one of its inputs should be set t
o true, or its output should be connected to something.
End Warning
Info: 2011-08-16 13:47:16.35
Code: 0x40043006
Source: Data Flow Task SSIS.Pipeline
Description: Prepare for Execute phase is beginning.
End Info
Info: 2011-08-16 13:47:16.38
Code: 0x40043007
Source: Data Flow Task SSIS.Pipeline
Description: Pre-Execute phase is beginning.
End Info
Error: 2011-08-16 13:47:16.40
Code: 0xC0047062
Source: Data Flow Task XML Source [1]
Description: System.ArgumentException: Value does not fall within the expecte
d range.
at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSBufferManager100.FindColumnBy
LineageID(Int32 hBufferType, Int32 nLineageID)
at Microsoft.SqlServer.Dts.Pipeline.DtsDataTable.SetupColumns(IDTSOutput100 o
utput, Int32 localeID, IDTSBufferManager100 bufferManager)
at Microsoft.SqlServer.Dts.Pipeline.DtsDataTableCollection.AssociateTablesWit
hBuffers(IDTSOutputCollection100 outputs, IDTSBufferManager100 bufferManager, In
t32 localeID, DataSet dataSet)
at Microsoft.SqlServer.Dts.Pipeline.DtsDataTableCollection..ctor(XmlSourceAda
pter xmlSourceAdapter, IDTSOutputCollection100 outputs, Int32 localeID, DataSet
dataSet, IDTSBufferManager100 bufferManager)
at Microsoft.SqlServer.Dts.Pipeline.XmlSourceAdapter.PreExecute()
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSM
anagedComponentWrapper100 wrapper)
End Error
Error: 2011-08-16 13:47:16.41
Code: 0xC004701A
Source: Data Flow Task SSIS.Pipeline
Description: component "XML Source" (1) failed the pre-execute phase and retu
rned error code 0x80070057.
End Error
Info: 2011-08-16 13:47:16.41
Code: 0x4004300B
Source: Data Flow Task SSIS.Pipeline
Description: "component "ADO NET Line" (1261)" wrote 0 rows.
End Info
Info: 2011-08-16 13:47:16.41
Code: 0x4004300B
Source: Data Flow Task SSIS.Pipeline
Description: "component "ADO NET Criteria" (2067)" wrote 0 rows.
End Info
Info: 2011-08-16 13:47:16.41
Code: 0x40043009
Source: Data Flow Task SSIS.Pipeline
Description: Cleanup phase is beginning.
End Info
Warning: 2011-08-16 13:47:16.41
Code: 0x80019002
Source: Foreach Loop Container
Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution
method succeeded, but the number of errors raised (2) reached the maximum allow
ed (1); resulting in failure. This occurs when the number of errors reaches the
number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the e
rrors.
End Warning
Warning: 2011-08-16 13:47:16.41
Code: 0x80019002
Source: Import_TrackTraceXML
Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution
method succeeded, but the n
Free Windows Admin Tool Kit Click here and download it now
August 27th, 2011 8:11am
Hello Daniel,
Do you still have this issue unresolved?
If not, try running this job using DTExec and tell us what happened.
The possible issue is the account you are running the SSIS SQL Agent jobs under.Arthur My Blog
August 27th, 2011 9:38am
Your XML source has an issue (Description: System.ArgumentException: Value does not fall within the expecte
d range.), also that Multicast warning is something not right. Please review your package for a potential pitfall.
Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
August 27th, 2011 9:42am