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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics