Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
makimark
Starting Member
34 Posts |
 Posted - 2004-07-12 : 00:58:48
|
| HiProblem as follows. I call and execute my DTS Package in vb.net as per pkg.LoadFromSqlServer(params). I then added a dynamic properties task to the dts package and created a global variable called filename. in vb.net just after the pkg.LoadFromSqlServer i add the code: "pkg.GlobalVariables.Item("Filename").Value = mypath.value.tostring " but i get a big fat error during dts execution where it does not add the global variable value. Is there a trick to this ?thanks |
|
|
|
|
|
Global Variable in VB.NET