<div>
Use <b>Row.ColName=&quot;Value&quot;</b><br />
<br />
Here is an article,<br />
<br />
<a href="http://www.sqlis.com/post/The-Script-Component-as-a-Transformation.aspx" rel="ugc">http://www.sqlis.com/post/The-Script-Component-as-a-Transformation.aspx</a><br />

</div>


Use Row.ColName="Value"

Here is an article,

http://www.sqlis.com/post/The-Script-Component-as-a-Transformation.aspx [http://www.sqlis.com/post/The-Script-Component-as-a-Transformation.aspx]


<div>
<div class="content wysiwyg-content">
I have an SSIS 'Script Component' which takes a number of input columns from the SSIS pipeline. Within the script component I have the following default code (see code). What I need is a way to iterate through all of the columns in the Input0Buffer and process them individually. This is a task that is going to be used in many different places with a number of different input columns so the solution needs to be generic. Any ideas?<br />
<br />

<pre><code id="code-8146020">Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

End Sub</code></pre>
</div>
</div>


I have an SSIS 'Script Component' which takes a number of input columns from the SSIS pipeline. Within the script component I have the following default code (see code). What I need is a way to iterate through all of the columns in the Input0Buffer and process them individually. This is a task that is going to be used in many different places with a number of different input columns so the solution needs to be generic. Any ideas?


Get Column Name/Value pairs from a script component SSIS.

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

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.