Hi,
I'm running DTSs from a Windows Service developed with VS2003 (.Net 1.1.).
I need to update some Global Variables values (in the same way I do with
parameter /A of DTSRun.exe).
Those Variables are String Variables. Those variables are used from a
DynamicProperty Task to update the Output file of a Text File Source Task.

So, I loaded the package in a Package2 Object, and try to set the value for
my Global Variables before call Execute.
I got this error:

"The object in GlobalVariable 'MyVariable' could not be persisted. It should
be
dynamically added to and removed from the GlobalVariables collection during
Package execution. No such interface supported"

Any idea to solve this problem?

Thanks a lot

LucasC

A good place to start is with this article

DTS Global Variables and Visual Basic .Net
(http://www.sqldts.com/default.aspx?265)


"LucasC" <msdn (AT) rmya (DOT) com.ar> wrote

Thank you.
Is there any additional solution for the Issue about the String Global
Variables? Is it a problem of .Net or DTSs?
Thanks again

LucasC

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> escribió en el mensaje
news:u%23xBT4NqFHA.4056 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

Allan,

Your post saved me a huge amount of time! I was passing a String
GlobalVariable to DTS from VB.NET and it wasn't working until I changed the
VB.NET to remove/re-add the parameter on the fly. I would still be scratching
my head had I not read your post - thank you!!!

Todd Langdon
tlangdon (AT) yahoo (DOT) com

"Allan Mitchell" wrote: