CozyRoc's blog

Released CozyRoc SSIS+ 1.4 SR-2 (1.4.102.0). The release includes the following major changes:

• Fixed: Template Task now provides more diagnostic information during the generation process.
• Fixed: ODBC Destination component failed occasionally with "Specified cast is not valid." error when processing INTEGER columns in MySQL.
• New: Salesforce Destination component now supports update and delete of records.
• Fixed: Script Component Plus failed to upgrade properly from 2005 to 2008.
• Fixed: Database Partitions Task was broken.
• Fixed: Table Difference component failed to process DT_DBTIME2 column types in SQL 2008 (Thank you, Ethan).
• New: A new option PassiveIgnoreAddress in FTPS Connection Manager to specify to ignore provided IP address in passive mode. This option is useful when the remote server is incorrectly configured.
• Fixed: EDI Source failed to load configuration files containing special characters like 1D, 1E, etc (Thank you, Bryan).
• Fixed: Script Component Plus 2008 was not updating the setup tab after script modification.
• Fixed: Disabled zlib compression in SSH Connection Manager because of file corruption (Thank you, Dmitry).
• New: A new option undefinedFail in EDI Source configuration file. If set to false, the component will not fail when new fields, components and sub-components appear in the input file.

Released CozyRoc SSIS+ 1.3 SR-6 (1.3.106.0). This release includes following major changes:

• Fixed: DB2 Destination and Informix Destination components inserted one extra rogue record (Thank you, Senthil).
• Fixed: FTPS Connection Manager was not able to upload a file in resume mode.
• Fixed: DB2 Destination and Informix Destination components failed with SQL dump in specific situations.
• Fixed: DB2 Destination and Informix Destination components did not include the fractional part of time stamp columns.
• Fixed: When RemoveSource property was set in Zip Task:
  • Source specified with file pattern was not removed.
  • If folder name was specified as a source, the complete folder was removed recursively even when IncludeSubfolders property was not set.
• Fixed: FTPS Connection Manager didn’t parse correctly Unix and Windows file names, which included two or more spaces.
• Fixed: The metadata of the data flow components was not upgraded after upgrade to SSIS 2008 package. This caused failure in the user interface and required remove and reinsert of component.
• New: Included Update license key command in License application.
• Fixed: Oracle Destination can now write BLOB columns.
• Fixed: Zip Task failed to decompress zip files greater than 2gb.
• Fixed: EDI Source component didn’t provide useful diagnostic information, when loading configuration file with errors.
• Fixed: Database Partitions Task was broken.
• Fixed: EDI Source failed to load configuration files containing special characters like 1D, 1E, etc (Thank you, Bryan).
• Fixed: Disabled zlib compression in SSH Connection Manager because of file corruption.

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.