title: How to add parameters to Oledb Source in ssis programmatically
body: <p>I am creating an ssis package which contains an OLE DB Source.</p>
  
  <p>The OLE DB Source component execute SP is:</p>
  
  <pre><code>EXEC [dbo].[USP_GetCustomerEtlSourceDetailRecordSet] @OrganizationName=?,@SourceRunID=?
  </code></pre>
  
  <p>How do I create parameters using C# code to pass to the above SP?</p>
  
  <p>I tried this, and it's not working, how do I map "@OrganizationName" parameter which is <strong>Project Parameter</strong>?</p>
  
  <pre><code>Guid variableGuid = new Guid(proj.Parameters["OrganizationName"].ID);
  Guid SourceRunID = new Guid(Parent_ETLSourceRunId.ID);
  String Parent_ETLSourceRunId1 = @"""@OrganizationName"",{" + variableGuid.ToString().ToUpper() + @"}" + ";" + @"""@SourceRunID"",{" + SourceRunID.ToString().ToUpper() + @"};""";
  srcDesignTime.SetComponentProperty("ParameterMapping", Parent_ETLSourceRunId1);
  </code></pre>