Sample template text to create CSV from DataReader Destination
In the Template Editor dialog, check the 'Remove Newline' parameter. The Current object below implements the standard ADO.NET IDataReader interface.
#macro( main $reader )#set( $schemaCols = $reader.Current.GetSchemaTable().Rows )## Setup header.#set( $comma = false )#foreach($col in $schemaCols)#if( $comma ),#else#set( $comma = true )#end$col.ColumnName#end#newline()## Setup data.#foreach($row in $reader)#set( $comma = false )#foreach($col in $schemaCols)#if( $comma ),#else#set( $comma = true )#end$row.get_Item($col.ColumnName)#end#newline()#end#end#main( $reader )
Book a Presales Call
Related Articles
Pass two objects to the Template Task
1 2 3 4 5 #macro( main $list1 $list2 ) ... ... #end #main( $list1 $list2 )What is the difference between Template Task and Template Component
Template Task have to be used when you would like to generate complex document, with input from multiple data flows. The Template component is recommended when you would like to generate result document, based only on one data flow input columns.Create an HTML table from ADO.NET Dataset (requires 1.4 SR-1)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 #macro( main $ds ) #set( $table = $ds.Tables.get_Item(0) ) <table> <tbody> <tr> #foreach($col in $table.Columns) <th>$col.ColumnName</th> #end </tr> #foreach($row in $table.Rows) ...Create an HTML table from ADO Recordset (requires 1.4 SR-1)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 #macro( main $rs ) <table> <tbody> <tr> #foreach($field in $rs.Fields) <th>$field.Name</th> #end </tr> #foreach($record in $rs) <tr> #foreach($field in $record) ...Where can I find the documentation for the Template Task?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Template Task can be found at the following link. For many of the components you can find resources ...