C#

Microsoft.SqlServer.Dts.Runtime.Application app=new Microsoft.SqlServer.Dts.Runtime.Application();            
Package package = null;
string pkgloctn;
pkgloctn = @"E:\XXXXX\XXXXX\Package.dtsx";
package = app.LoadPackage(pkgloctn, null);
package.Variables["User::FileName"].Value = txtCustSupport.Text.Trim();
Microsoft.SqlServer.Dts.Runtime.DTSExecResult results = package.Execute();

SELECT  ID, Doc_No, Rcv_Date, 
FROM            [SDC Documents Record] A
WHERE           (ID =
                   (SELECT        TOP 1 ID
                   FROM            [SDC Documents Record]
                   WHERE        (A.Doc_No = Doc_No)
                   ORDER BY    Rcv_Date DESC))