renaming multiple tables in one dts package
Index
‹
SQL Server
‹
SQL Server Developer
Author
Message
bburkhart
Posted: Wed Mar 16 14:18:42 CST 2005
Top
SQL Server Developer >> renaming multiple tables in one dts package
is it possible to rename multiple tables in one package? right now I have
this and it does not work:
sp_rename 'Temp_Table_1', 'Table1';
sp_rename 'Temp_Table_2', 'Table2';
sp_rename 'Temp_Table_3', 'Table3';
sp_rename 'Temp_Table_4', 'Table4';
sp_rename 'Temp_Table_5', 'Table5';
I have also tried without semi-colons and also with comma's
SQL Server230
Anith
Posted: Wed Mar 16 14:18:42 CST 2005
Top
SQL Server Developer >> renaming multiple tables in one dts package Use EXEC before the procedure name like:
EXEC sp_rename 'Temp_Table_1', 'Table1';
EXEC sp_rename 'Temp_Table_2', 'Table2';
...
--
Anith
Index
‹
SQL Server
‹
SQL Server Developer