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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Help,How to Create DTSGlobalVariable from a var?

Author  Topic 

hearnie
Starting Member

49 Posts

Posted - 2005-05-25 : 09:33:48
Hi All,

I am trying to setup a few DTSGlobalVariables in a DTS package by reading the set of values from a .ini file
File format is
varitem=varvalue

So instead of creating a DTSGlobal as follows
DTSGlobalVariables("server1").Value = "path"

I would like to be able to place the varitem in a variable and then pass this as the variable name to make the package more versitile and configurable, like the following

gVar = varitem
gVarValue = varvalue
DTSGlobalVariables(gVar).Value = gVarValue

Each time I run this script I get a type mismatch, does anyone know how to achieve this????

Thanks in advance

H.
   

- Advertisement -