Hi,
I've never used DTS before, so sorry if this is a stupid question. I am setting a global variable with the SQL Server name from a .ini file. This is so we can move from the dev server to testing and to production easily. In my package, I'm executing another local package. If I manually change the SQL Server name in the "Execute Package" task to a different server, I noticed that the package name and GUID gets wiped out.
So if I'm changing the SQL Server name via a .ini file, is SQL Server going to be smart enough to execute the same package name on the new SQL Server?
I hope that made sense. Please let me know if you need me to clarify anything.
Adam
while(ignorance){perpetuate(violence,fear,hatred);life=life-1};
I've never used DTS before, so sorry if this is a stupid question. I am setting a global variable with the SQL Server name from a .ini file. This is so we can move from the dev server to testing and to production easily. In my package, I'm executing another local package. If I manually change the SQL Server name in the "Execute Package" task to a different server, I noticed that the package name and GUID gets wiped out.
So if I'm changing the SQL Server name via a .ini file, is SQL Server going to be smart enough to execute the same package name on the new SQL Server?
I hope that made sense. Please let me know if you need me to clarify anything.
Adam
while(ignorance){perpetuate(violence,fear,hatred);life=life-1};