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 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

---

]]>