Code change to • Integration Services package (dtsx) built on SQL Server 2008 Standard

Description Current Process The package currently takes a 'flat file' ( CSV) from a specific network folder address ( for example T:\02output\) and transforms this flat file into a XML file which it then saves to another network folder address ( for example T:\03xmlexact). The XML files is a Sales Order file for an ERP Package Contained in the script code is some logic that adds 'freight lines' to the Sales Order, the relevant excerpt of this code is below // adding freight if (quantity > 0) { sql = @"SELECT [login to view URL] FROM staffl st INNER JOIN cicmpy c ON c.cmp_wwn=[login to view URL] WHERE [login to view URL] ='FREIGHT' and LTRIM(RTRIM([login to view URL]))='" + [login to view URL]("'", "''") + "' and '" + orderDate2 + @"' between [login to view URL] and [login to view URL] order by [login to view URL] "; cmd = new OleDbCommand(sql, cnn); OleDbDataReader dr = [login to view URL](); int i = 2; // line no while ([login to view URL]()) { string artcode = [login to view URL](0).Trim(); el = (XmlElement)[login to view URL]("//eExact/Orders/Order/OrderLine").Clone(); [login to view URL]["lineNo"].Value = [login to view URL](); [login to view URL]("Item").Attributes["code"].Value = artcode; if (artcode == "FRT") [login to view URL]("Quantity").InnerText = "1"; [login to view URL]("//eExact/Orders/Order").AppendChild(el); i++; } } Requirement We need to add some further logic to the code which determines when freight lines should be added. Currently freight lines are always applied if (quantity > 0) in the code extract above We wish this to be changed so that in addition to the condition that ' if (quantity > 0)' that freight will only be applied where the haulier and debtor fields in the inputted 'flat file' meet the additional conditions below Haulier in ('A002', 'B002','C001','M002') or the Haulier = 'A001' and Debtor <> '1027' or Haulier = 'D002' and Debtor not in ('1049','1119') or Haulier = 'R001' and Debtor <> '1027' or Haulier = 'R101' and Debtor not in ('1003','1165','1119') or Haulier = 'S001' and Debtor <> '1027' The Microsoft Visual C# 2008 code of the attached package should be changed for these extra conditions