Global variables to Data transformation task

• vinodacharyabv

  Grasshopper

  Points: 17

  More actions

  November 28, 2007 at 5:21 am

  #200928

  I am writing a script task in SSIS then i am assigning the result to a global variables or package level variable in SSIS . Now i want to assign Package level variable i.e SQL commant to a OLEDB source of data transformation task . How to do it? Please help me out.

• Norman Kelm

  SSCommitted

  Points: 1922

  More actions

  November 28, 2007 at 7:07 am

  #754956

  Assuming that the number of columns and column names will always be the same...

  Set up the data transformation with a sql command with a static version of your query.

  Change the OLEDB connection to use SQL Command from variable. Pick your variable,

  Norman

  DTS Package Search

  http://www.dtspackagesearch.com/