• Are there ways for me to replace the flat source file name and database table name with variables?

    -I started with the Execute SQL task in control flow, trying to use a variable for a table name in that area first.

    -Trying to piece together information on how to accomplish this from different websites, but I have hit a stand still.

    *listed attachments display print screens of my settings.

    1.

    The 'value' of my 'execute' variable is:

    TRUNCATE TABLE [nevada].[dbo]@tableName;

    ----------

    2.

    My ResultSetType is set to: ResultSetType_None

    -----------

    3.

    Resulting Error when debugging:

    [Execute SQL Task] Error: Executing the query "TRUNCATE TABLE [nevada].[dbo]@tableName;" failed with the following error: "Parameter name is unrecognized.". Possible failure reasons: Problems with the query"ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    -Parameter Name is 0

    -ResultSet is greyed out in 'edit' of Execute Sql Task

    -Connection is established, package runs fine when my new variables are not in place.

    Thank you.