Pass two objects to the Template Task
1 2 3 4 5 | #macro( main $list1 $list2 )
...
...
#end
#main( $list1 $list2 )
|
Book a Presales Call
Related Articles
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. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 #macro( main $reader ) ...
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.
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 ...
How to resolve File Transfer Task failing when no files exist.
This KB article is not relevant if you are using "Get Remote Files List" action on File Transfer Task. Instead, you can use this COZYROC prepared Javascript: https://www.cozyroc.com/ssis/script-ftp-file-exists-task If you are not sure there will be ...
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) ...