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.