Thanks, but that doesn't really help. Here's the latest query I tried, still spits out the same error in SSIS:

DECLARE @sql VARCHAR(MAX)

SET @sql = 'SELECT * FROM ' + @dataTableName

DECLARE...