SQL Server Performance

Using Golbal variable in Activex scripts.

Discussion in 'SQL Server 2005 Integration Services' started by pallavi, Feb 27, 2006.

  1. pallavi New Member

    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
  2. pallavi New Member

    Hi All,

    The problem was with some other code, DTSGlobalVariables works fine.

    Sorry for inconvenience

    Warm Regards!
    Pallavi

Share This Page