Single record file -> data variable -> Exec Sql input parameter

• Barkingdog

  SSCoach

  Points: 18670

  More actions

  March 17, 2010 at 12:33 am

  #139502

  I have a text file containing a single row of data, such as the number 36. I want to read that data value and pass it into an "Execute SQL Task" as an input parameter to a stored proc.

  (I am trying to read the data value into an SSIS variable that can be passed to the Execute SQL Task but I'm not having any success)

  Any ideas much appreciated.

  TIA,

  barkingdog

• Phil Parkin

  SSC Guru

  Points: 246979

  More actions

  March 17, 2010 at 3:28 am

  #1135053

  Use an OPENROWSET Execute SQL task to select the data.

  Map the result of the Execute SQL task to a variable.

  Use the variable as part of an Expression (SQLStatementSource) for your next Execute SQL task ...

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel