How to read the custom property value from a pipeline component.
Hi All,
I created a custom Pipeline component. I created a custom UI for the same. What I am trying to do here is that I display all the connection managers available in the package in a dropdown, when selected one, I set the value in the design time. the code looks
like this.
-----Custom UI class
public
bool
Edit(System.Windows.Forms.IWin32Window
parentWindow, Variables
vars, Connections
cons)
{
// Create and display the form for the user interface.
MyCustomUIForm
componentEditor = new
MyCustomUIForm(cons,
vars, md);
DialogResult
result = componentEditor.ShowDialog(parentWindow);
if
(result == DialogResult.OK)
return
true;
return
false;
}
-----Windows form
private
void
button1_Click(object
sender, EventArgs
e)
{
if
(designTimeInstance == null)
designTimeInstance = metaData.Instantiate();
designTimeInstance.SetComponentProperty(
"CustomProperty0",
comboBox1.SelectedText);
designTimeInstance.SetComponentProperty(
"CustomProperty1",
comboBox2.SelectedText);
this.button1.DialogResult
= DialogResult.OK;
this.Close();
}
Now When I attached this into my pipeline component, everything works fine. But I want to read the values of the custom properties with in the pipeline. Which object model of SSIS I need to use to get the value?
THanks
-Sajin
November 17th, 2010 10:04am
I don't understand your question.
You say "everything works fine", and then ask how to read the values. How is everything working fine then? It obviously isn't.
So - please tell us what is working, and then tell us what you mean by "reading" the values. What do you want to read them for? Where are you intending to use the value?
Talk to me now on
Free Windows Admin Tool Kit Click here and download it now
November 18th, 2010 11:41am