Details are as follows:

Package versions:

Microsoft SQL Server Integration Services Designer Version 9.00.4035.00
Microsoft Visual Studio 2005 Version 8.0.50727.42
Microsoft .NET Framework Version 2.0.50727 SP2

We have an SSIS package which uploads an xml file. There are a number of
tasks that perform basic validation and business logic tests before uploading
the file into the database. One of these tasks fails on about 2/10000 files.
This task creates a data-table and loops through the xml, performs some
checks and adds a row to the data-table if certain business rules are met. In
the case of the files that are failing, they each fail at the same point in
the code. The line of code is trying to add an item to the table. We can
force an insert into the table without error if we run the code in debug and
stop it directly above the ‘Insert’ line of code – this does not cause an
error but allowing the code to continue will throw the error.


Error Message:
DTS Script Task has encountered an exception in user code:
Project name: ScriptTask_980022ca904a4fd09e3463f14589240a
Min (1) must be less than or equal to max (10) in a Range object.
at System.Data.Select.GetBinaryFilteredRecords()
at System.Data.Select.SelectRows()
at System.Data.DataTable.Select(String filterExpression)
at ScriptTask_980022ca904a4fd09e3463f14589240a.Script Main.Main() in
dts://Scripts/ScriptTask_980022ca904a4fd09e3463f14589240a/ScriptMain:line 332


If you need any more info, please ask.

Thanks in advance
David