InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 02:52:55 GMT20http://www.sqlservercentral.com/Forums/Topic1359539-364-1.aspxtry creating a stored proc and pass this column as a parameter (varchar(max)) and use exec @paramSun, 16 Sep 2012 21:14:17 GMTsqlbi.vvamsihttp://www.sqlservercentral.com/Forums/Topic1359539-364-1.aspxHello 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.Fri, 14 Sep 2012 12:00:26 GMTkumar-378458