How To Pass A Table Name As A Parmater In SQL Task

I am trying to execute an SQL task in a ForEach container that is the table name for a select statment I want to execute (table name is passed from a rowset created before the ForEach container).

ForEach Container is looping correctly (I've used a watch to make sure each of the table names in the previous rowset are being passed correctly). I want to use the table name to execute the following query:

Select count(*) as TableRowCount from MyLinkedServer...?

(with ? as the table name)

Problem I am having is that the SQL Task Editor keeps placing a space between the last period and the parameter and then telling me it cannot parse the SQL.

I tried:

Declare @SQL varchar(255)

Set @SQL = 'Select count(*) as TableRowCount from MyLinkedServer...' + ?

Exec(@SQL)

Same error as above. My parameter is varTableName

If I used the Declare and hardcode the table name (i.e. MyLinkedServer...MyTable), and it works fine. Just doesn't seem to want to allow the table name as a parameter...

Thoughts, ideas??? Am very new to SQL 2005 but did the above with DTS... Thank you for any assistance...

Danno