Global vars & dynamic connections | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Global vars & dynamic connections

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’.
Check the website and search for ‘Global Variable’ word which will return you with code examples. _________
Satya SKJ