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
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
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) ...Validation error. CozyRoc File Transfer Task <TASK NAME>: '<CONNECTION MANAGER NAME>' connection is not 'FILE' type.'
Action: When configuring a package using the File Transfer Task, the following error is encountered. Error Message: Validation error. CozyRoc File Transfer Task <TASK NAME>: '<CONNECTION MANAGER NAME>' connection is not 'FILE' type.' Solutions: This ...