If I read the question properly you can do this with the object model.
Something like this
Changing the DTS Send Mail Task
http://www.sqldts.com/default.aspx?6,102,235,0,1
Is this what you want?
--
----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Per Schjetne" <per.schjetne (AT) dmhuset (DOT) no> wrote
Quote:
I have a custom task developed in VB and I can access its properies easily
in an ActiveX script using the Package.Tasks collection.
I want to change propeties of the CustomTask of a given task, but how?? I
know I can do this with the DynamicProperties task, but I want to change
several CustomTasks dynamically/programmaly. How to simulate the job
DynamicProperties does? |