Blogs

CozyRoc has just learned there is backward compatibility issue under the 64bit Windows Server 2008 R2 edition (Thank you, Natali). The issue is the same like the one reported a couple of weeks ago in Windows 7. After installing CozyRoc SSIS+ the opening of SSIS packages is no longer possible. We are trying to resolve the issue with the Windows team. In the meantime you can use the manual fix we have published in the FAQ.

We have released 5 brand new data flow script components:

• Google Data Source – Get data from Google Service.
• ADO.NET Command Transformation – Execute SQL command for each row in a data set.
• Range Dictionary Destination – Creates memory-efficient dictionary object for value ranges. The object can then be used in CozyRoc Lookup Plus component.
• Levenshtein Distance Transformation – Calculates the difference between two strings.
• Soundex Transformation – Creates Soundex representation of input string.

Enjoy!

We have included sample SSIS packages demonstrating CozyRoc components. This has been long overdue and we are sure you will like them. Let us know what other samples you want to see.

We are excited to report CozyRoc has acquired the full rights to SQLBI‘s Table Difference and Flow Synchronization components. The solution is well known and accepted by the market as faster alternative to the standard SCD component. SQLBI and CozyRoc believe this is the right approach to address:

• Customer concerns about critical support issues handling in timely manner.
• Improved installation and deployment.
• Continued future innovation.

The components are now integrated in SSIS+ 1.4 SR-1 and ready to be used.

ps: We would like to Thank You SQLBI for their contributions to the SSIS community!

Released CozyRoc SSIS+ 1.4 SR-1 (1.4.101.0). Existing customers may have to update their license keys to use the new components below. The release includes following major changes:

• Fixed: Salesforce Source component failed to load object with more than 250 rows of data.
• New: A new option ColumnLength in EDI Source component to specify column length of EDI elements.
• Fixed: ODBC Destination component failed to load to table with long text columns.
• Fixed: Zip Task failed to decompress zip files greater than 2gb.
• New: A new option IncludeDeleted in Salesforce Source component to retrieve all records, including deleted.
• Fixed: The number field types are now setup as numeric in Salesforce Source component (Thank you, Wes).
• Fixed: Salesforce Destination component failed under SQL 2008 when ErrorDescription column was not used.
• New: A new option ServerUrl in Salesforce Connection Manager to specify service URL. This is useful for sandbox testing (Thank you, Frank).
• Fixed: EDI Source component didn’t provide useful diagnostic information, when loading configuration file with errors.
• New: SQLBI’s Table Difference component is now part of SSIS+ library.
• New: SQLBI’s Flow Synchronization component is now part of SSIS+ library.

Merry Christmas to Everyone!

There is a backward compatibility issue under the 64bit Windows 7 edition. After installing CozyRoc SSIS+ the opening of SSIS packages is no longer possible. We are trying to resolve the issue with the Windows team. In the meantime you can use the manual fix we have published in the FAQ.

There is only one way for storing data in-memory when using the standard SSIS data flow components. It is based around the old ADO Recordset object and therefore limited only to 32bit package executions. We have implemented a new script component for storing data into in-memory ADO.NET DataSet object. Cheers!

The 2009 PASS Summit was a great success for CozyRoc! We thank for the opportunity to meet and exchange ideas with the vibrant SQL Server community and Microsoft developers. We also want to extend special greetings to all our existing customers who found time in their busy schedule to come by CozyRoc’s booth. Many of the attendees were happy to find about CozyRoc, its new products and try the delicious Lindt chocolate truffles. Networking in person gave us new perspectives and valuable feedback for improving CozyRoc’s technology.

This year CozyRoc celebrates third year in business. Celebrate with this Special One-Time Offer. Buy SSIS+ Ultimate Subscription for $399.95/Year in November and get 3 (three)* license keys.

The other Ultimate SSIS+ Subscription features:

• Library is licensed per physical machine
• Premium support
• License for previous, current or future versions
• Licenses expire, if not renewed

* The regular subscription includes 2 (two) license keys.

In September 2008 we set a goal to develop the most powerful and important suite of tools for every SSIS developer! Some of the new features are only found in much more expensive data integration systems.

We deliver all with CozyRoc SSIS+ 1.4 Library!

Summary of the products available immediately for purchase:

• SSIS+ Ultimate Subscription at $399.95/Year
• SSIS+ 1.4 perpetual license at $899.95
• USPS Address Database / One time purchase at $299.95
• USPS Address Database / Monthly Subscription at $199.95/Month
• SSIS+ Premium Support at $499.95/Year

For more information, check the purchase page.

Summary of the new / updated components

• Script Component Plus – Extends Microsoft Script component for greater usability and maintenance.
• Template Task – Generation of arbitrary text documents.
• Data Flow Task Plus – Dynamic data flows.
• Address Parse – US Postal Address parse and correction.
• ODBC Destination – Regular and bulk-load of data in ODBC table.
• SCP Task – Secure copying of files.
• Lookup Plus – Simplified and enhanced lookup transformation.
• Salesforce Source – Load data from Salesforce service.
• Salesforce Destination – Store data to Salesforce service.
• Salesforce Connection Manager – Connections with Salesforce service.