Home Forums Data Warehousing Integration Services SSIS usimg varible with ADO.Net Execute SQL Task "Failed to convert parameter value from a String to a Int32." RE: SSIS usimg varible with ADO.Net Execute SQL Task "Failed to convert parameter value from a String to a Int32."

  • 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