how assign Variables in SQL Server Integration Services in oledb sourse.

• subbu1

  Hall of Fame

  Points: 3281

  More actions

  June 19, 2012 at 12:29 am

  #257714

  Could you please tell how to aassigv varaible to below mentation code in oledb sourse.

  i am trying to bap but it was showing error

  declare @date datetime=?

  select * from policy

  where firstissuedate=?

• subbu1

  Hall of Fame

  Points: 3281

  More actions

  June 19, 2012 at 3:54 am

  #1502668

  thanks for your replay...

  i was tried as your told that why but it is not working..

  when i had selected parameter it is show error..

  declare @date datetime=(

  select * from policy

  where firstissuedate=? )