Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Bring Text datatype data from sql table and pass to Execute SQL task or something to create a table Expand / Collapse
Author
Message
Posted Friday, September 14, 2012 12:00 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, December 6, 2013 2:20 PM
Points: 14, Visits: 72
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
Posted Sunday, September 16, 2012 9:14 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 4:51 PM
Points: 54, Visits: 368
try creating a stored proc and pass this column as a parameter (varchar(max)) and use exec @param
Post #1359954
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse