I like that much better!! If you execute the DTS Packages via DTSRUN.exe, it is simple to pass in global variables as parameters that are set at run time within the VBS file.
My blog: SQL Soldier[/url] SQL Server Best Practices: SQL Server Best Practices Twitter: @SQLSoldier My book: Pro SQL Server 2008 Mirroring[/url] Microsoft Certified Master: SQL Server, Data Platform MVP Database Engineer at BlueMountain Capital Management[/url]