COZYROC SSIS+ 1.6 now officially released

COZYROC SSIS+ 1.6 is out of beta. We can now say this is the most ambitious release of the SSIS+ library. The new release includes 15 new adapters, 8 new connection managers and many other enhancements like support for SQL 2012, dynamic data flow transformations, Dynamics CRM 2011 web services, Salesforce bulk-load API, SharePoint 365 and many others. In total it took 22 months of development to deliver this amazing package. We would like to Thank all our loyal customers for their support and assistance!

Summary of the products available immediately for purchase:

• SSIS+ Ultimate Subscription at $399.95/Year
• SSIS+ 1.6 perpetual license at $2,399.95
• SAS® Adapters license at $2,499.95
• USPS Address Database / One time purchase at $299.95
• USPS Address Database / Monthly Subscription at $2,399.95/Year
• SSIS+ Premium Support at $499.95/Year

For more information, check the purchase page.

Summary of the new / updated components

• Support for SQL 2012.
• Salesforce Destination - Support for bulk-load.
• Data Flow Task Plus - Support for dynamic data flow transformations.
• Dynamics CRM Connection Manager - Support for CRM 2011 web services (Office 365, Federation, Live).
• Dynamics CRM Destination - Support for Upsert action.
• QuickBooks Source - Load data from Intuit QuickBooks.
• QuickBooks Destination - Store data to Intuit QuickBooks.
• QuickBooks Connection Manager - Connections with Intuit QuickBooks.
• Teradata Destination - Bulk load adapter for Teradata database.
• Sage Source - Load data from Sage SData service.
• Sage Destination - Store data to Sage SData service.
• Sage Connection Manager - Connections with Sage SData service.
• Dynamics GP Source - Load data from Microsoft Dynamics GP service.
• Dynamics GP Destination - Store data to Microsoft Dynamics GP service.
• Dynamics GP Connection Manager - Connections with Microsoft Dynamics GP service.
• OpenAir Source - Load data from OpenAir service.
• OpenAir Destination - Store data to OpenAir service.
• OpenAir Connection Manager - Connections with OpenAir service.
• Template Transformation - Data flow transformation for generating output columns based on Apache Velocity template.
• NetSuite Source - Load data from NetSuite service.
• NetSuite Destination - Store data to NetSuite service.
• NetSuite Connection Manager - Connections with NetSuite service.
• Exchange Connection Manager - Connections with Microsoft Exchange email service.
• SugarCRM Source - Load data from SugarCRM service.
• SugarCRM Destination - Store data to SugarCRM service.
• SugarCRM Connection Manager - Connections with SugarCRM service.
• Dynamics NAV Source - Load data from Dynamics NAV service.
• Dynamics NAV Destination - Store data to Dynamics NAV service.
• Dynamics NAV Connection Manager - Connections with Dynamics NAV service.

Known Issues

• Table Difference component is not working properly under SQL 2012 official. There is a bug in the SQL 2012 serialization code, which is scheduled to be fixed in CU 3.
• Parallel Loop Task is not always working properly under SQL 2012. We are still trying to determine the root cause. Please contact us, if you experience issues.
• Lookup Plus component in existing packages is incompatible with SQL 2012. Make sure you check the documentation how to prepare your packages for upgrade to SQL 2012.