SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
A community member has associated this post with a similar question:
how to assign print result to output variable of a stored procedure
Only moderators can edit this content.
saving a create table script in a SSIS variable
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 82%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
Nishan Ratna
150
Reputation points
Hi all,
I use a tsql query to generate a create table script. Once I run the query with print @SQL command, I get the create table script. However I get it in the message tab. ( please see the image below). now I want to create a SSIS package and save this result (create table script) in a variable. Is this possible?
SQL Server Integration Services
{count} votes