25 Nov sql server Index was outside the bounds of the Array Microsoft.SqlServer.smo
You can Choose 'Result to File' option in SSMS and export your select result to file and make your changes in result file and finally using BCP - Bulk copy you can insert in table 1 in database 2. You can install and integrate ApexSQL...