Cursors in transformation

Hi , i am trying to use sql cursor in transfornation job but every time i execute it it shows " error near or at @". I am using @ to declare variable for eg @sample int