I made a Mistake above
The error is
[Execute SQL Task] Error: Executing the query "DECLARE @AssetsDB as varchar(50)
set @AssetsDB
= ..." failed with the following error: "Incorrect syntax near '@AssetsDB'.".
Possible failure reasons: Problems with the query, "ResultSet" property not set correctly,
parameters not set correctly, or connection not established correctly.
DECLARE @AssetsDB as varchar(50)
set @AssetsDB = @Assets (the variable mapping)
--select db_id(@AssetsDB)
if db_id(@AssetsDB) is not null
drop database @AssetsDB;
else
create database @AssetsDB;
go
USE @AssetsDB;
GO