This is the case: I wrote a simple task that has one property Display text, it displays text once the package if fired. This built in task has an interface. The user should normally enter the display text property value and click OK then that value is persisted.
If the user interface is closed then reopened then this value should be held as normally.
Should I write custom code to cache this value and then write a code to persist it or this is done through a provided way by the SSIS, I asked this question before and CosyRock oriented me to some code samples which I followed with a great intention but
until now I couldn't figure out how to persist properties values.
In this case I use the IDtsTaskUI interface to tie the task to its interface and you know there isn't an Edit method such is IDtsComponent interface so I can imlement it to commit or rollback values?
The complexity resides in the simplicity
View Complete Post