Fetch a date from Execute SQL Task into a variable

• Guy Haskell

  Ten Centuries

  Points: 1242

  More actions

  October 18, 2007 at 10:56 am

  #375920

  Hi all,

  This has got to be the simplest part of the package I am building, but the one providing me with the most frustration!

  All I am trying to do is select a single date into a variable.

  My ResultSetType is SingleRow, I have a date variable mapped to Result Name 0 on the Result Set settings.

  The task executes "successfully", but it never seems to set the value of the variable and consequently the rest of my package does nothing.

  Anyone succeeded at this sort of thing?

  The SSIS designer I'm using is 9.00.3042.00.

  Thanks

• Guy Haskell

  Ten Centuries

  Points: 1242

  More actions

  October 19, 2007 at 9:16 am

  #743672

  GAH! I can't believe I wasted so much time on this....I was just trying to unit-test my package as I write it.

  It all works when I run it as a whole, it just doesn't update variables in the vars window after a task runs......DOH!