How to pass a table value as a variable in SSIS

• Jim Slade

  Newbie

  Points: 7

  More actions

  November 6, 2007 at 1:12 pm

  #119370

  Hi, Big Jim here:

  I was hoping someone could point me in the right direction for this.

  I would like to pass a value from a table or a text file to the SQL Command Text in an OLE DB Source Editor as a variable. The Source is an ORACLE db while the destination is SQL 2005. I hope this is enough information. I am sure there are tutorials out there for something this simple, but I have not had much luck finding them.

  Thanks in advance,

  Big Jim

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  November 7, 2007 at 8:42 am

  #749127

  Here is a good example - http://blogs.conchango.com/jamiethomson/archive/2005/12/09/SSIS_3A00_-Using-dynamic-SQL-in-an-OLE-DB-Source-component.aspx

  Tommy

  Follow @sqlscribe