Dynamic Table Name on Select Into

DECLARE @DatabaseName VARCHAR(50)
DECLARE @SchemaName VARCHAR(50)
DECLARE @SelectFromTableName VARCHAR(50)

SET @DatabaseName='Sales'--database you want to read from and create new table in
SET @SchemaName='dbo'--schema you want to read from and create new table under
SET @SelectFromTableName='Customers'--table you want to read from

DECLARE @Sql VARCHAR(500)
DECLARE @TableNamePrefix VARCHAR(20)='Customers'---replace this string with what you want to name your new table
DECLARE @TableNameSuffix VARCHAR(10) = CONVERT(VARCHAR, CAST(GETDATE() AS DATE), 105)
DECLARE @TableName VARCHAR(31)=@TableNamePrefix + '_' + @TableNameSuffix

BEGIN TRY
SET @Sql=
'
  SELECT * INTO '
   + @DatabaseName + '.' + @SchemaName + '.[' + @TableName + '] FROM '
   + @DatabaseName + '.' + @SchemaName + '.' + @SelectFromTableName
EXEC(@sql);

PRINT 'You have created table ' + @TableName + ' with ' + CAST(@@RowCount as VARCHAR) + ' Rows';
END TRY
BEGIN CATCH
IF (ERROR_NUMBER()=208) --invalid object name
BEGIN
PRINT 'You need to specify a valid database table';
END
ELSE
IF (ERROR_NUMBER()=2714)--object you are trying to create already exists
BEGIN
PRINT 'Table ' + @TableName + ' already exists';
END
ELSE
BEGIN
PRINT ERROR_MESSAGE();
END
END CATCH