Login Register  
Skip Navigation LinksHome > News
News and Announcements
FirstPrev Page:124589 NextLastAll
Version 3.34 of the Keelio Software products has been released!

Version 3.34 has been released and contains a performance enhancement with the template transformation component.


  1. The Template Transformation component now defaults to not allow expressions on any component properties.  This will greatly speed up Business Intelligence Development Studio (BIDS) aka Visual Studio when developing SSIS packages.  Read the upgrade documentation PDF file on the new property called "AllowColumnExpressions" for more information. 
Version 3.33 of the Keelio Software products has been released!

Version 3.33 has been released and contains several improvements with the template transformation component.


  1. The SQL 2008/2008 R2 template transformation UI did not properly initialize in 3.32.  This issue has been fixed (3.32 will no longer be available due to this issue). 
  2. The template transformation mapping ID's window now auto sorts alphabetically.
  3. The eConnect task now outputs the error information to the SSIS logging facility.  This allows for centralized logging without having to email the log information to the user.  This will also make it possible to see much more information about the integration in the event of an error (assuming logging is setup on your SSIS package).
Version 3.32 of the Keelio Software products has been released!

Version 3.32 has been released and contains several improvements with the template transformation component.


  1. Template transformation component would not output the correct rows data if using mapping ID's within the "Last Record of Primary Key" template type.
  2. Occasionally you may get an "Invalid number of output columns" error on the template transformation if certain scenarios occurred in the data flow which caused one or more input or output columns to change (such as changes in data types or column names, or by copying the component to another data flow source).  When this occured you had to re-setup the template transformation task.  You no longer have to do this as all of the metadata should be re-initializing correctly.
Version 3.31 of the Keelio Software products has been released!

UPDATED 11/19/2010: 3.31 has been released and replaces 3.30.  A bug was found in the XML Merge component when contained within a dataflow that is contained within a for each loop container which would result in incorrect XML being generated if using the XML Merge component.  This issue has been fixed.

This release is the first release that no longer has the XML Destination and XML Transformation components included in the toolkit any longer (see 3.20 announcement for more details).  If you are still using the XML Destination or XML Transformation components and need assistance getting them upgraded to the template transformation please email us at support@keelio.com


  1. Template transformation NULL detection has been fixed for BLOB columns (TEXT, NTEXT, IMAGE, BINARY) columns.
  2. You can now change the output column names in the template output components (useful when chaining together multiple template output components).
  3. Documentation updates.
  4. Updated installer.
  5. Changed registration installer file name so Windows 7/2008 R2 installer detection does not think it is an installer executable.
Version 3.22 of the Keelio Software products has been released!

Version 3.22 contains several important bug fixes with the Template Transformation data flow component.  Anyone using the component is recommended to upgrade to this latest version.  Due to issues discovered during this release we have pulled 3.20 and 3.21 from the website and they will no longer be available as they can cause data loss when using the template transformation.

This release contains the following updates:

  1. Data loss would occur during buffer transitions when using the template transformation due to the way buffer state was maintained.  This occurred in both the 3.20 and 3.21 versions of the component.
  2. AccessViolationException could occur when using the template transformation.  Turns out this appears to be an SSIS bug that can't be easily remedied and is not specific to our components but can occur with out of the box components as well.  To tackle this issue we have built in a safeguard which should protect users for the majority of cases of this bug when using the template transformation by setting an in memory buffer.  The buffer size is user selectable and data is written to the downstream pipeline when the buffersize has reached a defined memory limit.  This limits the number of times we set data in the pipeline buffer and therefore minimizes the occurance of AccessViolationExceptions.
  3. Primary key detection may fail in random scenarios in all components that use primary keys (XML Merge, XML Transformation, and Template Transformation).  This was due to the way the keys were stored in memory and will no longer occur as we have moved to a known safe key storage technique.
  4. Base64 and Hex encodings have been added to the template transformation component by utilizing specialized escape lists (read documentation for more information).
FirstPrev Page:124589 NextLastAll