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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » Bring Text datatype data from sql table and...

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

Rate Topic

Display Mode

Topic Options

Author

Message

kumar-378458

Posted Friday, September 14, 2012 12:00 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, September 28, 2012 11:41 AM
Points: 10, Visits: 50

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.

Post #1359539

sqlbi.vvamsi

Posted Sunday, September 16, 2012 9:14 PM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 10:11 AM
Points: 48, Visits: 269

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

Post #1359954

« Prev Topic | Next Topic »

Permissions