Paul,

I get the same error...Here are a bit more detail on execute sql task:

General tab:

resultset: None

connectionType: OLE DB

connection: UserServerConnection

sqlsourceType: Direct input

sqlstatement: insert into tmpTLogFileList(FileName) values (@FileName)

bypassPrepare: True

The Parameter Mapping is same above as you mention, except

for Data Type - Nvarchar, I can't fine the dropdown for String.

I appreciate all you help thanks....

Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query "insert into tmpTLogFileList(FileName) values (@FileName)" failed with the following error: "Must declare the scalar variable "@FileName".". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Task failed: Execute SQL Task