Need to use a variable from package level to ole db source

• conningtower

  Say Hey Kid

  Points: 675

  More actions

  October 24, 2009 at 8:50 am

  #205913

  Hi All

  What i m trying to do is,

  1. Passing a variable [PaidWeight] from C# to my Package.

  2. At my package end I created a package variable [PaidWeight]

  3. I execute my package from C# code

  4. I need to pass this variable from the Package scope to the Data Flow task ' OLE DB Source

  where i can use this sql query

  Declare @var AS Char(1)

  set @var = <<<NEED to give my SSIS variable @[User::PaidWeight] here>>>

  SELECT PaidWeight =

  CASE

  WHEN M.Weight = '0' THEN @var

  ELSE CEILING(M.Weight)

  END

  FROM MailPieceBuffer M

  I think there should be a way to get this achieved. If not this way pls suggest an alternative way for it.

  Thanking you

  Gomz

• SinisterPenguin

  SSC Eights!

  Points: 898

  More actions

  October 26, 2009 at 3:34 am

  #1070578

  Hi - I would set up my your query like this in the Data source of the data flow (assuming an oleDB source)

  SELECT PaidWeight =

  CASE

  WHEN M.Weight = '0' THEN ?

  ELSE CEILING(M.Weight)

  END

  FROM MailPieceBuffer M

  Then use the parameters button of the data source to map the parameter (?) to your package variable.

  Unless I am totally missing the point here 🙂

  Hope this is useful

  S C Pengiun