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

  • 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.

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply