OK, if your're running exactly the same code - and you may want to check it's exactly the same - then it's got to be environmental. Try putting SET QUOTED_IDENTIFIER ON at the top in SSMS and see whether you get an error, or try putting SET QUOTED_IDENTIFIER OFF at the top of your code in SSIS and see whether that stops the error.

John