SQL Server Performance

Global vars & dynamic connections

Discussion in 'SQL Server DTS-Related Questions' started by bgsd, Oct 25, 2003.

  1. bgsd New Member

    I built & used a dts package to import txt files into existing SQL tables. I ran the package from within DotNet with great success. Now I wish to use this
    package to perform the same task but allow the end user to:

    1) change the path of the source tables
    2) change the ServerID, i.e. (local)

    I added global variables & a 'Dynamic Properties Task' to the package to map global vars to conn properties. Now when I run the package I can see the assignment of the global vars at runtime, but the transformations never take place, & there are no error messages. Why?

    FYI: The only connection property I am changing is the datasource. The catalog, the username, password, tablename must stay the same. I've also saved changed the Package Scanning Options to 'Scan Catalogs always'.

  2. satya Moderator

    Check thehttp://www.sqldts.com website and search for 'Global Variable' word which will return you with code examples.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page