Using SSIS, how to Read and Execute SQL Code that is stored in a column

• onlygoodones

  SSC Eights!

  Points: 870

  More actions

  March 1, 2012 at 11:22 pm

  #391704

  Hello every one,

  I have a Varchar(max) column that saves basic TSQL Code.

  I need a way to read that code and execute it using SSIS package.

  Any thoughts on how to do this is appreciated..

  Thanks in advance

• okbangas

  SSChampion

  Points: 11773

  More actions

  March 2, 2012 at 4:29 am

  #1454090

  Two ways of doing this:

  Execute SQL Task to retrieve the SQL into a variable.

  Another Execute SQL Tasks which executes the data in this variable

  or

  Excute SQL Task which store retrives the data into as SQL Server variable, and then use sp_executesql to execute the it.

  ---

  
  Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

  Concatenating Row Values in Transact-SQL[/url]