Passing Date vriable between SSIS steps

• simon phoenix-479217

  SSCommitted

  Points: 1573

  More actions

  September 16, 2008 at 3:05 pm

  #382675

  Hi

  Fellows

  I have to Pass date variable between steps of SSIS steps. How do i do that

  Scenario: I am taking max date from Server A( i am the SA in that box). I have to use the same date in next steps where connection belongs to Server B, where i have access to only one Database.

  i am trying to retrieve the date from server A by using following query

  @Lastdate=(select CONVERT(datetime, CONVERT(Varchar(10),?,101)))

  It gives me the error,

  'The query failed to parse. Syntax error, permission violation , or other non specific error'

  Could somebody provide some insight on this

  Thanks

  Simon

• SrikanthSv

  Ten Centuries

  Points: 1197

  More actions

  September 16, 2008 at 3:16 pm

  #872729

  are you using ssis for this

  if so assign the date variable using the result set mapping in execute sql task

  use this variable further

  Regards
  Venkat
  http://sqlblogging.blogspot.com[/url]