<div>
You want to write a variable from SSIS to a text file?<br />
this is simply possible by script task<br />
just you need to open file in this task and write value of variable inside it.<br />

</div>


You want to write a variable from SSIS to a text file?
this is simply possible by script task
just you need to open file in this task and write value of variable inside it.


<div>
Thankyou for the Comments, I tried each one with varying success.<br />

</div>


Thankyou for the Comments, I tried each one with varying success.


<div>
<div class="content wysiwyg-content">
I have a string from a CLR Stored Procedure i want to insert into a text file, i have tried various ways and i think at the moment the best way is maybe via a variable. Is it possible to insert a variable value into a text file via SSIS?
</div>
</div>


I have a string from a CLR Stored Procedure i want to insert into a text file, i have tried various ways and i think at the moment the best way is maybe via a variable. Is it possible to insert a variable value into a text file via SSIS?

Insert a variable into a text file SSIS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.