SQL Server Performance Forum – Threads Archive

Using Golbal variable in Activex scripts.

Hi All I am creating a package to transfer the data from approx 200 Excel files to a Table, all these files are on d:Excelfiles. This path is different on diffetent machines where the package is installed. Previously I was using SQL 2000, I created a package which uses the Activex script to transfer this . I was sotring the path as DTS Variable, and use this variable in the activex script using the DTSGlobalVariables("FilePath").Value. Script VB Script. It was working fine. Now I have to migrated the same package to SQL 2005, but the same script from SQL 2000 doesnot work in SQL 2005. Also I dont know how to use the golbal variable in the activex script. Pls can any one tell me how can I use the global varible in the Activex. Warm Regards!
Pallavi

---

Hi All, The problem was with some other code, DTSGlobalVariables works fine. Sorry for inconvenience Warm Regards!
Pallavi

---

]]>