how to get external variable value in dtsx package.
- by Rishabh
Hi,
I am executing .dtsx package from c#, it was executing fine, if i am passing one variable value from c# code then how can i get it on .dtsx package for my ole db source query. Here is my c# code.
string file = @"D:\CYNCZFuzzy\CYNCZFuzzy\Contact.dtsx";
package = app.LoadPackage(file, null);
Variables vars = package.Variables;
vars["User::parentContactID"].Value = 1028203;
pkgResults = package.Execute();
string result = pkgResults.ToString();
I need this 1028203 value on my ole db source query, here my query.
select cr.MasterContactID as ParentContactID,
c.ID,C.FirstName,
C.MiddleName,
c.LastName,
c.ID as FieldID
from Contact c inner join
ContactRelation cr on cr.SlaveContactID = c.ID
where RelationshipID = 1
AND cr.MasterContactID = ?
what I should write on ? for getting 1028203 value from c# page.
Thanks in advance...
