Forum Discussion
tristaanogre
14 years agoEsteemed Contributor
Change the line for your path to the following:
Notice that I removed the closing backslash. If you have that extra slash in there, while the scripts don't log an error, they do record that the rename was not possible.
So, the rename is not what's populating the new column, the next row where you are renaming SQL Server to SQLServer, because the FIRST rename folder failed, is populating the new folder.
Correct that constant and see if that helps.
Const Path = "D:\Scripts\Scripts"
Notice that I removed the closing backslash. If you have that extra slash in there, while the scripts don't log an error, they do record that the rename was not possible.
So, the rename is not what's populating the new column, the next row where you are renaming SQL Server to SQLServer, because the FIRST rename folder failed, is populating the new folder.
Correct that constant and see if that helps.