Will something like this work?

Insert into [dbo].[Linux_Collections_Archive]

SELECT *

from [dbo].[Linux_Server_Collections]

USE [MSB_Data]

GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Linux_Server_Collections]') AND type in (N'U'))

TRUNCATE TABLE [dbo].[Linux_Server_Collections]

GO

USE [MSB_Data]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER...