Version 5.30 has been released. 

Enhancements:

• SQL Server 2022 Support.
• Visual Studio 2022 Support.

Version 5.20 has been released. 

Enhancements:

• SQL Server 2019 Support.

Version 5.11 has been released. 

Enhancements:

• Update for SSDT VS 2017 installation detection.

Version 5.10 has been released. 

Enhancements:

• SQL Server 2017 support has been added.
• Dynamics GP 2018 support added.
• .NET Framework 4.5 or higher now required.

Version 5.00 has been released. 

Enhancements:

• SQL Server 2016 support has been added.
• SQL Server Data Tools for Visual Studio 2015 support added.
• SQL Server 2005 through 2008 R2 SSIS Support deprecated. Current and future versions will target SQL Server 2012 and above.
• Other minor bug fixes and enhancements.

Version 4.28 has been released. 

Enhancements:

• Dynamics GP 2016 support has been added.

Version 4.26 has been released. 

Enhancements:

• Dynamics GP 2015 and 2015 R2 support.

Version 4.24 has been released. 

Enhancements:

• SQL 2014 support.
• Graphical glitch fixes for Visual Studio 2013 development environments.

Version 4.23 has been released. 

Enhancements:

• Corrected issue where next document number task would not save properties on SQL 2012.

Version 4.22 has been released. 

Enhancements:

• Corrected UI issue where Dynamics GP version was not getting set properly on various components.

Version 4.20 has been released. 

Enhancements:

• Added Dynamics GP 2013 support.
• Corrected STA (Single Threaded Apartment) error when doing meta data refreshes on the Template Transformation component.
• Corrected datatype change issue when refreshing column on template transformation component.
• Significant eConnect performance enhancements.

Version 4.11 has been released. 

Bug fixes:

• In the SQL 2005 version of the components deleting a template row would cause two rows to be deleted instead of just the one selected row.

Version 4.10 has been released. 

New features in this release:

• Template transformation component now has an IntelliPrompt / IntelliSense editor which allows for intelligent XML creation using XSD file definitions.
• Template editors do automatic node completion while typing in XML.
• Template editors show XSD document comments while typing.
• Template editors show line numbers to more easily see carriage return / line feed breaks.
• Template editor now performs XML highlighting.
• Template editor windows retain the window size and splitter positions. Addtionally more splitters have been added to resize more of the window.
• Template mapping ID's can now be dragged/dropped into the editors rather then double clicking on them.
• All eConnect XSD's are included in the installation package.

Bug fixes:

• In certain scenarios null text columns would cause the template not to output correctly and you would loose some data in the template when using the automatic whitespace trimming functionality.
• Dynamics GP next document number components would not authenticate properly within the UI if using a connection with SQL Authentication.

Version 4.02 has been released. 

Updates in this release:

• All eConnect components updated to include a CommandTimeout property to prevent timeouts on extremely large eConnect XML documents.

Version 4.01 has been released. 

Updates in this release:

• Updated validation procedure on Dynamics GP next document transformation component.

Version 4.00 has been released. 

Updates in this release:

• Auto trimming support in Template Transformation component
• SQL 2012 Support
• New registration key format that no longer requires internet connection
• Code optimization
• All .NET encoding formats are now supported in all components

Version 3.36 has been released.  This is a minor maintenance release.

Fixes in this release:

• Blank NULL text on a column which was actually NULL would cause the prefix and post text to be outputted instead of the NULL Text data.
• Installer would not grant proper permissions to a registry key the software uses which would cause problems for non-administrative accounts.
• Installer will automatically launch registration tool after installation has finished.

Version 3.35 has been released and contains a bug fix for escape list functionality in the template transformation.

UPDATE 3-3-2011: The 3.35 installer files have been re-published due to an issue where the new AllowColumnExpressions value was not being refreshed properly in the user interface.

Fixes: The Template Transformation would not obey escape list settings properly for releases 3.33 and 3.34 due to a bug fix that was introduced after 3.32 was released.  This issue would cause the component to fail when using escape lists on a column. 

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

Enhancements:

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 has been released and contains several improvements with the template transformation component.

Enhancements:

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 has been released and contains several improvements with the template transformation component.

Enhancements:

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.

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. 

Enhancements:

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 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).

 Version 3.21 contains several important bug fixes with the Template Transformation data flow component.  Anyone using the component is recommended to upgrade to this latest version.

This release contains the following updates:

1. Template transformation issue where columns could not be removed properly after adding them in either the standard editor or the advanced editor.
2. Fix for template transformation error that would occur if no rows enter the component.
3. Updated samples installer that now guides you through install process based on what samples you have installed and you can now select which samples you wish to setup instead of being forced to setup all samples.
4. Documentation updates.

This release contains a new component that will replace both the XML Destination Adapter as well as the XML Transformation adapter and is called the Template Transformation.  This component can do all of the things that the XML Destination and XML Transformation components can accomplish but can also do many more things that customers have requested. 

The XML Destination adapter and XML Transformation components will still be supported.  However they will be removed from all future versions of the product as of November 1st, 2010.  If you wish to upgrade to versions that are released past that date you will need to convert your existing integrations to utilize the new template transformation task.

Template Transformation Features:

1. Very low memory utilization. The component can write data to the downstream pipeline almost immediately therefore there is no longer memory constraints with our tool as we can offload the data as soon as it hits the component. This has essentially reduced the memory footprint on most documents by around 98%.
2. Much more granular control on how you create documents. Customer feedback necessitated the change to make this more of a template tool as the other XML creation components restricted you in many ways in the way you generate your XML and therefore failed in many customer situations unless you wrote XML "fixup" code after the initial document had been created.
3. There is usually no need to ever use the XML Formatter tool any longer as you can design your templates in a way that would make it so that the XML data always comes out formatted properly. This will also increase the performance of your integrations due to one less step the integration has to perform.
4. Built in XML and HTML escaping. Previous components only had XML escaping.  In fact now the escaping is completely user customizable on a column by column basis.
5. Built in XML data cleansing to remove characters outside of the valid XML range as defined by the W3C. No data cleansing was performed in the previous components.
6. Ability to create non-XML based documents.
7. Faster XML creation using the tool, instead of defining many XML nodes and levels you can now use one of the many free XML editors available and define the structure of your XML within that editor and copy and paste in the XML fragments into the template transformation tool instead of defining all of the rigid levels and nodes as you had to do in the previous versions of the component.

This release contains the following additional updates:

1. Dynamics GP 2010 support.
2. Automatic document numbering for many document types within the Dynamics GP eConnect task as defined in the eConnect SDK.
3. SQL 2008 R2 tested.
4. All samples have been rewritten to utilize the new Template Transformation component.

NOTICE: This release contains several very important changes that will affect the compatibility with previous packages.  Be sure to read the update instructions in the Upgrade Notices document as you will be required to run a conversion tool if you are upgrading from a previous version of our products to this version.

UPDATE: 3/12/2010 - 3.17 has been replaced with 3.18 after finding a bug in the XML Transformation component that caused certain scenarios for depth levels to not work properly.

This release contains the following updates/fixes:

1. New Dynamics GP Next Document Number Transformation component.  This will allow you to get next document numbers from Dynamics GP within the data flow of SSIS.
2. Consolidated Dynamics GP components.  There are no longer components seperated by version of Dynamics GP, instead there is just one version of each component and you select the version of Dynamics GP you want the component to run against.  This will greatly simplify upgrades of SSIS packages from version to version of Dynamics GP.
3. Many documentation updates in the user manual.  Upgrade notices are now in their own document included in the download.
4. Several new XML SSIS Toolkit samples have been added.
5. XML Transformation and XML Merge components now have a buffer option to allow for streaming to a file instead of relying on everything to be in memory.  This should only be used in scenarios where your server does not have enough memory but it has a considerable performance overhead.
6. Updated Project Converter tool for the Dynamics GP component updates.
7. General GUI cleanup.
8. Consolidated all GP Samples and made installer program ask which version of Dynamics GP you are using to setup the samples accordingly.
9. New XML Formatter option to use XDocument (LINQ) parsing which is faster and requires less memory then the old way of parsing (XmlDocument).
10. General speed improvements throughout all of the code which has also reduced the library size considerably.
11. Value type option in style drop down in XML Transformation and XML Destination adapters that allow you to add values after lead elements that have attributes.

This release is a maintenance release containing the following fixes:

• Dynamics GP eConnect and Next Document Number tasks were found to leak connections (keep open connections to the database server).  This issue has been corrected.

As with previous releases, be sure to read the manual for important upgrade documentation.

NOTICE: This release contains several very important changes that will affect the compatibility with previous packages.  Be sure to read the update instructions in the manuals as you will be required to run a conversion tool if you are upgrading from a previous version of our products to this version.

This release contains the following updates/fixes:

1. Integrated installer for all products.  SQL 2005 and SQL 2008 components are embedded into one installer.
2. Installer is now a pure MSI based installer.
3. All code has been consolidated and refactored into version specific DLL's.  This means that you can now have SQL 2005 and SQL 2008 components running side by side which will be helpful in development environments that deal with multiple SQL versions.
4. XML Merge component automatically refreshes when new columns are present.  In the past you had to go into the advanced editor and mark any new columns that were created from upstream components.
5. XML Transformation and XML Destination adapters have been updated so that no component properties are updated until you press the OK button.  In the past XML mappings were updated immediately. 
6. XML Transformation and XML Destination adapters now do validation on the OK button press.  This will make it so you can make any edits that you want without getting validation errors during row edits.  All validations are now handled at the very end of the component when you press the OK button. This will provide for a much better editing experience.
7. Fixed a validation error that would occur in the XML Transformation and XML Destination adapters when using attributes at depth level 1 when the output row element was unmarked.
8. Added more validation logic to XML Merge component.
9. Added more validation logic to the XML Destination and XML Transformation components.
10. XML Transformation and Destination adapters now handle upstream component changes better so that downstream components do not have to be updated as much or be completely remapped. 
11. Fixed a bug that would cause the XML merge component metadata to be corrupted when attaching to the component multiple times.
12. Updated installer utility to detect multiple sample types.
13. Added a project converter tool to upgrade from versions 2.41 to 3.14 to make those compatible with 3.15.
14. Dynamics GP SSIS and XML SSIS Toolkit manual updates.

This release is a maintenance release containing the following fixes:

1. Updated registration program with additional logging.
2. Updated XML Merge, XML Formatter, and XML Transformation components with additional logic to check for changes in upstream component changes such as data type changes, column changes, etc.
3. Transformation components now retain their settings when disconnected from parent components.
4. No longer checking if output is connected on transformation components as output connection can not be detected during validation.  This caused users to have to open the component editor to just hit OK so the component would refresh.  This step is no longer necessary.

This release is a hotfix release that contains the following fixes:

1. Registration program would error if you had a regional localization set on the operating system that allowed commas as a decimal seperator.
2. Updated Dynamics GP SSIS Toolkit and XML SSIS Toolkit manuals.

This release is a hotfix release that contains the following fixes:

1. XML Transformation component would not be properly initialized when put into a for loop container as rows would not have been added to the output buffer on subsequent iterations due to a variable not being reset in the component during the pre-execution phase of the component.
2. XML Merge component had variables that were not reinitialized during the pre-execution phase of the component which could cause more then one iteration through the component to fail (such as using a for loop container).

Update (June 3, 2009): Republished installer with the following additonal fixes:

1. When using a primary key the final iteration of the XML transformation component would output an additional blank row when it should not have.
2. Added an extra example to the Family tree examples to show how to add header and footer values over an entire collection of rows.

This release is a hotfix release for version 3.1.  We had fixed the depth level issue in the previous version, however it created another depth level issue.

This version will resolve the depth level tag closing issue that was present in the previous version of the components when dealing with decimal depth levels.

The version 3.1 download has been pulled from the site.  All users who updated to 3.1 are strongly encouraged to download this new version.

This release has introduced one new component to simplify XML merging. The new component aptly named XML Merge Transformation allows you to take two columns of data in a row and merge them together based on certain conditions you set. This should solve the majority of the XML merging scenarios without having to write custom .NET scripting code to do the same functionality as it has been done in the past. All samples have been updated to show this functionality.

Additionally there has been a very important change to the XML Transformation and XML Destination adapters that could affect existing integrations. The change affects how depth levels are treated when you have multiple decimal depth levels that are lead elements. Be sure to read the upgrade documentation for version 3.1 to identify if it will affect your existing integrations so that you can alter the depth levels appropriately in the new version.

Lastly, due to all the related fixes and new functionality we have decided to raise the price of all components $50 dollars. This does not affect existing customers as they will receive the updates with their existing maintenance plans.

Enhancements:

• Add XML Merge transformation component and many new samples that use that new functionality.
• Merged many of the XML SSIS Toolkit examples into single DTSX packages to make reading the samples easier.
• Added Omit XML Row option to XML Transformation and XML Destination Adapter components.
• Added offline registration capability.
• Added row element name blank validation to XML Transformation and XML Destination adapters.
• Updated existing samples to utilize the new XML merge functionality.

Bug Fixes:

• XML Transformation and XML Destination adapter would not output decimal depth levels marked as lead elements at the proper level when already nested inside of a depth level at the same level.  For instance a depth level of 2.1 nested inside of a level 2 would not put it at the correct level, it would go one level deeper then it should have.
  • Important: Read the documentation on why this was done and if it can affect your current integrations.
• Fixed inconsistent metadata issue with XML formatter task that would occur when you remapped parent columns that would cause the lineage ID's to change further down the pipeline.
• Fixed depth level 1.1 issue with XML Transformation and XML Destination components.  Would receive a stack empty error when attempting to use these depth levels.
• Corrected a scenario where you reconnect a parent component which would then cause the XML mappings to get corrupted in the XML Transformation and XML Destination adapters (inconsistent meta data).
• Corrected a bug where it would remove the XML output column in the XML Transformation component when you were in the advanced editor and hit the refresh button.

• Added row element name is blank validation function to XML Transformation and XML Destination adapter components.

This release is a hotfix for the version 3.0 release a few days ago.  The following issues have been corrected in this release:

• XML Transformation adapter did not properly handle attributes at depth level 1 when attaching them to the row level element.
• The File Task did not refresh the user interface properly due to case sensitivity issues with the drop down controls.

This release has ushered in two new data flow components: XML Transformation and XML Formatter Transformation.

The XML Transformation allows you to map source data as XML within the pipeline and output the resulting XML into an XML text column (NTEXT).  It can do this for every row or if the data is sorted you can specify a primary key and on the change of the primary key it will output the row to the children pipeline components.  As you can see this would be very powerful as you can then use the join transformations that come with SSIS to then merge many-to-many and one-to-many relationships together.

During the merging process it is often necessary to reformat your XML as it will get slightly unformatted (missing indents).  The XML Formatter tool allows you to reformat your XML by adding or removing idents, and changing encoding format (UTF-8, UTF-16, UTF-32, etc).

Be sure to checkout the Family Tree examples in the XML SSIS Toolkit for a demonstration of the new functionality.

Enhancements:

• Two new components created, the XML Transformation data flow component and the XML Formatter transformation data flow component.
• Additional validation has been added to the XML Destination Adapter
• Code refactoring (some minor speed increases)

All versions of the Keelio Software products have been upgraded to version 2.42.  This release contains several important bug fixes.  Any user using a previous 2.X version of the components should upgrade to this release to avoid potential component property corruption.

Bug Fixes:

1. XML Destination Adapter may end up with corrupt component propertys in a specific scenario.
2. Attributes with NULL data would cause the XML adapter to fail
3. Installer would not properly log installed versions of .NET framework

Enhancements:

1. Dynamics GP eConnect adapters now contain more progress status messages.

There have been several maintenance plan renewal changes at Keelio Software.  The model that was used in the past has been replaced by a much simpler fixed price model.

Additionally you can now purchase renewals at any time from our website instead of receiving individual invoices for renewals.

This has been done to simplify the renewal process for both our customers and partners.

A bug has been identified that caused the depth level to be incorrectly decremented in a specific scenario.  If you have upgraded to version 2.4 please use this latest release.

Version 2.4 has been released of all Keelio Software components.  There have been many changes in this released.  Read the update section of the documentation for information on upgrade procedures.

New Features:

1. Document and Row level namespace support.
2. Explicit ordering is now supported.
3. New line on attributes option has been added.
4. Document and Row level aliasing support (Local names)
5. Column level namespace lookups are supported
6. IMAGE and BINARY data is now automatically converted to Base64
7. String concatenation task now has the ability to reformat (properly indent) any XML data.  This is useful when you want to have complete formatting after putting XML fragments together.
8. XML Lang attribute support
9. XML Destination adapter automatically reverts to a raw write mode when prefixes are used without a namespace context
10. 19 New XML samples have been included in the XML SSIS Toolkit
11. Several UI enhancements in the XML Destination Adapter

Bug Fixes:

1. Version check on registration key utility now works for international cultures that do not used decimals for currency notation
2. Depth validation issue with non-decimal information
3. NTEXT and TEXT columns did not get outputted to the XML Destination

Registration keys for partners and customers are now available online.  Simply login to your account and go to the "My Accounts" tab and choose "My Registration Keys" to view your registration keys.

Your support expiration (annual maintenance expiration) is also shown in the "My Registration Keys" page.

Version 2.22 of the Keelio Software components have been released.

This is an incremental update that includes some enhancements to the registration utility to detail support expiration information. 

There are no changes in any of the SSIS components in this release.

Version 2.21 has been released and contains a bug fix for the XML Destination Adapter that was causing out of memory errors when writing XML documents of a significant size to the file system.

Please note that string variable output is still restricted to the memory that is available and addressable to the .NET framework so you are encouraged to only use that option for putting smaller XML fragments together to form complete XML documents and not for very large (100's of megabytes) XML documents as you can still receive out of memory exceptions when trying to store everything in memory.

All Keelio Software Products have been upgraded to version 2.2!  There have been several changes with this release.

• XML Destination Adapter can now have multiple lead elements on the same level.  This is accomplished by using decimal depth levels.
• Two new XML samples demonstrating the multiple lead elements concept have been added to the XML Toolkit samples.
• Validation is no longer done on each cell on the XML Destination mapping grid, but on a row level basis.  An issue was identified where people could get stuck in the window and have to close out of it using using the "X" box in the mapping window when trying set a new lead element on a row where the column depth was greater than 1.
• Corrected an issue where the first row of the mapping window would be overwritten because the focus first went to the "enable/disable" checkmark in the mapping window in the XML Destination Adapter.

All Keelio Software Products have been upgraded to version 2.1!  There have been several changes with this release.

• File Load Task has been renamed to File Task. The task now supports reading and writing from/to SSIS variables.
• File Task supports UTF-7, UTF-8, UTF-16, UTF-32, and ASCII (US-ASCII) file formats for reading and writing.
• Append capability has been added to the file task.
• Proxy bug fix with registration/installer program.

All Keelio Software Products have been upgraded to version 2.0!  There have been many changes during this release including the following:

• SQL 2008 Support has been added
• eConnect Tasks no longer require the eConnect Runtime to be installed on any SSIS Server.  The tasks have been rewritten to encapsulate the entire eConnect functionality and provide full SSIS transaction support!
• Registration Utility now has proxy server support
• XML Destination Adapter is now named the XML Destination Advanced Adapter.  This component has many new features such as the following:
  • Root document and name space capability
  • XML Preview support (view the XML document before you run the SSIS package!)
  • Multi-Level element and attribute support
  • Row level name space properties
  • UTF-7, UTF-8, UTF-16, UTF-32, and ASCII encoding support

The Dynamics GP SSIS and XML SSIS Toolkits have been updated with new features and bug fixes.  The new versions of both tools are now at 1.1.

New Features:

1. All variable assignment windows allow you to create variables on the fly.  You no longer have to create variables prior to assigning a variable to a property in the Dynamics GP and XML SSIS components.
2. eConnect Tasks have been improved to allow you to automatically assign eConnect header and footer strings so you can save yourself time from having to concatenate those strings together prior to passing it to the Dynamics GP eConnect Task.

Bug Fixes:

1. Synchronized all windows on how they operate with OK and Cancel buttons.  (Save buttons removed).
2. Fixed a label bug in registration window
3. Updated product manuals

The Dynamics GP SSIS Toolkit and XML SSIS Toolkit have been released!  Signup for a free 30 day trial today!

The release of the Dynamics GP SSIS Toolkit is scheduled for an early July release.  Stay tuned or subscribe to our RSS feed for updates.