I am sorry I think I didn't make myself clear. Here is another query.

Query:

declar @Table_Name varchar(500)

declar @string char(500)

set @Table_Name='S_EVT_ACT'

Select @string=string from @Table_Name

The problem is I don't want to use EXEC(@combined...

Hi Jack,

I do refresh the tables all the time and the problem still there. I think the problem is caused by the SSIS package is always 0 percent complete but...