how do you programmatically create an ole db source component parameter?

i'm attempting use cmanagedcomponentwrapper.setcomponentproperty method programmatically configure parameter in ole db source component, i'm unable work.  configured ole db source use ole db connection manager.  therefore, source query using the placeholder syntax (?) parameter.  have code sample of how done?  possible or not?  if not, there workaround?

tia

---

duane douglas, mcad | http://www.ssisbi.com | please mark post(s) answered question.

i'm attempting use cmanagedcomponentwrapper. setcomponentproperty method programmatically configure parameter in ole db source component, i'm unable work.  configured ole db source use ole db connection manager.  therefore, source query using the placeholder syntax (?) parameter.  have code sample of how done?  possible or not?  if not, there workaround?

tia

---

duane douglas, mcad | http://www.ssisbi.com | please mark post(s) answered question.

 

duane,

specify parameters setcomponentproperty method?

---

ssis tasks components scripts | http://www.cozyroc.com/

below code i'm using map parameter ssis variable:

srcdesigntimecomponent.setcomponentproperty("parameter0" , "user::customer" );

line of code throwing exception.  apparently, parameter0 custom property doesn't exist , isn't created when call setcomponentproperty method.  required define parameter before can call method? if so, how accomplished?  if not, there other way accomplish goal?

---

duane douglas, mcad | http://www.ssisbi.com | please mark post(s) answered question.

 

duane,

did create small test package find out ole db source storing. correct custom property have set named parametermapping . format of property (based on understanding) is:

"<parameter0 name>",<variable guid>;
"<parameter1 name>",<variable guid>;
...

can similar test , find yourself.

---

ssis tasks components scripts | http://www.cozyroc.com/

SQL Server  >  SQL Server Integration Services