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