Is it possible to change the Dataflow tasks properties with VB coding? I've managed to change the properties of the control Flow tasks with VB code! as I wan to create a generic dataflow that will change everytime I run it.
CheersYes, you can. It is a bit more complicated, as many of the properties are contained in a CustomProperties collection on the data flow objects, so you need to find the names of the specific properties that you are interested in.|||
Kolf wrote:
Hi,
Is it possible to change the Dataflow tasks properties with VB coding? I've managed to change the properties of the control Flow tasks with VB code! as I wan to create a generic dataflow that will change everytime I run it.
Cheers
Kolf,
You know that you cannot change this stuff while the package is running right? You need to affect the change prior to the package running.
-Jamie
|||would you be able to give me on example so it will keep me going, yes and I am aware of the issue that I need to change the properties prior to running the package. therefore it dataflow should be in a sub-package.
Thanks|||
would you be able to give me on example so it will keep me going, yes and I am aware of the issue that I need to change the properties prior to running the package. therefore it dataflow should be in a sub-package.
Thanks
This is quite a big area and I don't know of one example that covers everything. What in particular are you having trouble with? Navigating through the package to the property or knowing how to change it?
-Jamie
|||Thanks again Jamie, you've been very helpful
So there is no escape or work around this issue. I was hoping instead on using Transfer SQL Server object task (to copy the table to destination server, which dynamic tablelist feed – and using sub-package ), I could use dataflow tasks within one package (and avoid using sub-package and changing the property of the sub-package from parent package – as this is how it works now and it’s very slow) .
So I can use execute sql task to populate the table schema on the destination and then use a dataflowtask to push the data across , all in one package. And be able to put this in a loop to do for a list of tables.
I hope I’ve explained it clearly
|||would you be able to give me on example so it will keep me going, yes and I am aware of the issue that I need to change the properties prior to running the package. therefore it dataflow should be in a sub-package.
Thanks
Kolf,
Jessica Elise has posted some great code here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1404157&SiteID=1&mode=1 that may be of use.
-Jamie
