Bring Text datatype data from sql table and pass to Execute SQL task or something to create a table

• kumar-378458

  SSChasing Mays

  Points: 636

  More actions

  September 14, 2012 at 12:00 pm

  #266749

  Hello Team,

  I have a text datatype field in the database. It has a create table script. In a SSIS project i want to query this field and pass the value to backend again to execute as sql.

  How i can store this value of the field on SSIS side(because it can not fit in VARCHAR (8000)) and pass to execute sql task or any other thing. i have seen DT_TEXT field. But i am not sure on how to use this ?

  Alternatively i can explain the goal of task here.

  I have text field in the database which has create table script or any other bunch sql statements (just in one field). I want to execute from ssis based on a criteria. What are the options and how can i do that?

  Please suggest.

  Thanks,

  kmg.

• sqlbi.vvamsi

  Ten Centuries

  Points: 1194

  More actions

  September 16, 2012 at 9:14 pm

  #1538386

  try creating a stored proc and pass this column as a parameter (varchar(max)) and use exec @param