Using Variable inside sql command text

See more:

SSIS

In my SSIS, I’m using “OLE DB Source” and in “OLE DB Source Editor” in the “SQL Command text” box I have:

Declare myvar int
Set myvar = Dts.Variables["User::theID"].Value
SELECT    *   FROM   dbo.myTable     
where (myTableId  in (SELECT  (CASE myTableId WHEN 0 THEN max(myTableId)
                                      ELSE myTableId END)))

I also defined theID in as variable. But this is not working and gives me error.
Thank you in advance