You probably need to use dynamic sql in this case.  I was looking at BOL, and was curious, what if you try this:

in ((select @isps))

It would help if you could provide the DDL for your table, some sample data, and what the returned result set should look like.

We use the ExecuteProcess Task to FPT files to an MSP using sslftp.  I wrote a cmd file that is called in the Execute Process Task that uses a script...

And it is starting again in a different thread (and no, I'm not getting involved).

You will need to ask your friendly DBA to install the SQL Server 2005 client tools on your box (or where ever it is you need them).  If you have...

Try this:

     SET @QRY = '

           UPDATE

                 tblCR_MainData

July 26, 2007 at 2:52 pm