CozyRoc's blog

Released CozyRoc SSIS+ 1.5 SR-3 (1.5.103.0). The release includes the following major changes:

• Fixed: Salesforce Source component failed with “Failed to process …” error when processing input columns of type binary.
• New: A new option DetectDuplicate in Dynamics CRM Destination component to enable duplicate detection rules during create or update.
• Fixed: Excel Destination Plus component failed with “Unable to determine the identity of domain.” error, when trying to create larger xlsx file (Thank you, Cory).
• Fixed: Dynamics CRM Source component now handles better FetchXML statements containing linked entities.
• Fixed: Dynamics AX Destination component failed to update string fields containing quote (’) character.
• Fixed: Table Difference component incorrectly transformed NULL value input into empty string, when input column type was DT_TEXT or DT_NTEXT (Thank you, Michael).
• Fixed: Receive Mail Task failed to extract properly Unicode text attachments (Thank you, Patrick).
• Fixed: Template Task failed to generate result from data flow parameter in certain situations (Thank you, Federico).
• Fixed: Numerous fixes and enhancements in Data Flow Task Plus (Thank you, Eric).
• New: Salesforce Source component now supports aggregate SOQL statements (Thank you, Greg).
• Fixed: Executing child package containing Parallel Loop Task with inherited variable from parent package failed with error: “The object cannot be added because another object with the same name already exists in the collection. Use a different name to resolve this error.” (Thank you, Jacob).
• Fixed: Dynamics CRM Destination component was always reporting no error code (Thank you, Eric).
• New: New options Sender and Date in Receive Mail Task to extract email sender and origination date.
• New: Dynamics AX Destination component can now update array fields.
• Fixed: Zip Task created invalid packages when compressing empty files (Thank you, Cameron).
• Fixed: Table Difference component failed with “COM object that has been separated from its underlying RCW cannot be used.” error when processing input columns of type DT_TEXT or DT_NTEXT (Thank you, Michael).
• Fixed: ODBC Destination component truncated long text columns containing more than 65535 characters (Thank you, Doug).
• New: Dynamics CRM Destination component now supports adding and removing records in CampaignActivityItem and CampaignItem entities.

One of our great customers was kind enough to share their experience building an ETL solution with CozyRoc’s technology. You can check the first post from a series here. Watch out for more great material. Enjoy!

CozyRoc SSIS+ has been nominated for the 2011 SQL Server Magazine Community Choice Awards, category "Best Business Intelligence & Reporting Product". Vote Now to help us win this prestigious award.

The latest service release of the SSIS+ 1.5 library includes two new adapters for working with SAS® sas7bdat files:

• New: SAS® Data Source component for retrieving data from sas7bdat files.
• New: SAS® Data Destination component for writing data into sas7bdat files.

The components are implemented to have minimal memory consumption, using streaming and can process unlimited amounts of data. Also keep in mind that even though these new adapters are part of the same SSIS+ installation, they require separate premium subscription license (purchase of SSIS+ library license is not required). The CozyRoc SAS® adapters license cost is $2,499.95/Year.

There is price change of the CozyRoc SSIS+ 1.5 perpetual library license. The new price is $1,599.95 per license.

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

• New: SAS® Data Source component for retrieving data from sas7bdat files.
• New: SAS® Data Destination component for writing data into sas7bdat files.
• Fixed: ODBC Destination component failed with “String cannot be of zero length. Parameter name: oldValue” error when destination database is IBM Informix Dynamic Server.
• Fixed: Advanced Excel integration adapters are now multithread-safe.
• New: SFTP Task now reports bytes transferred, when sending/receiving files (Thank you, John).
• New: A new option NoAuthentication in SMTP Connection Manager.
• New: Lookup Plus component now uses multi-threaded lookups loading.
• Fixed: Dynamics CRM Connection Manager was not able to connect to hosted CRM service (Thank you, Joao).
• Fixed: Improved Table Difference component setup dialog loading speed, when using many columns.
• Fixed: SharePoint Destination component inserted incomplete date columns.
• Fixed: SSH Connection Manager failed with “Cannot access a disposed object.” error when using new backend engine.
• New: A new option LocalFilter in SFTP Task to set local file filter expression when using ‘Send files’ action.
• New: SharePoint Source component now includes column with list item’s attachments (Thank you, Anthony).
• New: Excel Source Plus component now supports named ranges.
• Fixed: Database Partitions Task failed to process tables with foreign keys, which reference multiple columns (Thank you, Sergio).
• New: Data Flow Task Plus now includes more options for processing flat files.
• New: A new option CreatePrimaryKeys in Database Partitions Task to create primary keys when using ‘Create Partition’ action.
• New: A new option IncludeHidden in SharePoint Source component to include list’s hidden fields.
• New: SFTP Task now supports move of multiple files, when using ‘Rename remote file’ action (Thank you, Richard).
• New: A new option MissingColumnFail in Data Flow Task Plus for dynamic destination components. When set, the task will fail if source column is missing in destination.
• Fixed: Data Flow Task Plus setup dialog was not opening properly, when package was in a solution with multiple SSIS projects (Thank you, Anthony).
• Fixed: Dynamics CRM Source component failed when certain FetchXML statements were specified (Thank you, Jamal).
• New: Database Partitions Task now supports SQL 2008 table compression option.
• New: Dynamics CRM Source component can now retrieve data from StringMap and ListMember entities.
• Fixed: Salesforce Source component failed with “INVALID_TYPE: sObject type ‘…’ is not supported.” error when processing certain SOQL statements containing relationships (Thank you, Jonlee).
• Fixed: Dynamics CRM Destination component failed to process input columns of type DT_NTEXT.
• Fixed: Address Parse component is now multithread-safe.
• New: Dynamics CRM Destination component now supports adding and removing records in ListMember entity.
• New: Dynamics CRM Destination component now supports update of more entity attributes.
• New: Dynamics CRM integration adapters now provide better error diagnostic information.
• New: Oracle Destination component is no longer dependent on specific version of Oracle Data Provider for .NET.
• New: DB2 Destination component is no longer dependent on specific version of IBM DB2 .NET Data Provider.
• New: Informix Destination component is no longer dependent on specific version of IBM Informix .NET Data Provider.
• Fixed: Salesforce Destination component failed with “Column data type is not supported by PipelineBuffer class.” error when processing input columns of type DT_DBDATE (Thank you, Ellen).
• New: New API methods in IMAP Connection Manager.
• New: Zip Task can now encrypt and decrypt AES encrypted files.
• Fixed: Parallel Loop Task didn’t update package-scoped variables used in the loop.
• Fixed: FTPS Connection Manager failed with “Already logged in (530)” error when connecting to certain servers with client certificate (Thank you, Ulia).
• New: A new option ObjectFilter in Salesforce Source component.
• New: Dynamics AX Destination component now uses optimized bulk-data insert.
• New: Dynamics CRM Connection Manager now supports CRM Live deployment  in EMEA and Asia.
• Fixed: SSH Connection Manager failed with “Bad Message” error when using Serv-U server and Remote parameter contained wildcard.
• New: Salesforce Destination component can now update foreign key lookups with external identifier.

We have just released 14 brand new script components and tasks:

• Column Compression Transformation – Data flow column compression.
• Google Maps Destination – Google Maps generation.
• Dynamics CRM Association Destination – Setup association between entities in Dynamics CRM.
• Dynamics CRM Relationship Destination – Setup relationship between entities in Dynamics CRM.
• IMAP Task – Management functions for IMAP mail servers.
• Map Replace Transformation – Transformation of data flow columns using dictionary object.
• Merge Setup Transformation – Setup and insertion of stage table data into destination table using SQL 2008’s MERGE T-TSQL.
• OData Source – Get data from OData source.
• Regex Extract Transformation – Extraction of information using regular expression.
• Secure Tunnel – Setup secure tunnel over SSH protocol.
• Table Update Destination – Easier table update.
• Test Data Source – Easy test data setup.
• WMI Source – Get data from WMI.
• XPath Transformation – Extract information from data flow column containing XML document, using XPath expression.

As 2010 comes to a close, I’d like to share some thoughts with everyone who had an impact on CozyRoc in the past year - all of our partners and clients, friends and the whole SQL Server tribe.

CozyRoc has been in the community for four years now. I had the opportunity to meet and get to know many of you at SQL Saturday events, at the Code Camps and of course at the PASS Summits. As these events are getting bigger and better with each year, it is an honor and privilege to be a part of them.

16 000 miles is a lot of travel for me. There were a lot of chilly mornings when we had to quickly set up our booth, lots and lots cup of coffees to keep me awake and aware :) I met hundreds and hundreds of people in over a dozen cities, some were genuinely interested in discovering the company and the software and others were genuinely interested in the awesome chocolate truffles and all give-aways we were prepared with.

I learned to listen more, although these were eye-to-eye events and probably single opportunity to sell yourself. Aggressive selling does not always pay off. I find it more rewarding to come up with answers to someone’s problem instead of asking generic questions. After all, it was during the weekends :)

My appreciation goes after all organizers and volunteers, because these events could not have been a reality without them. Thank you all!

See the list of events CozyRoc has sponsored, attended and exhibited in 2010 below.

--- Stacy Dimitrova, Director of Marketing

CozyRoc SSIS+ 1.5 SR-1 has been released and it includes new components for integration with Microsoft Dynamics AX and Distributed Cache Connection Manager for using Windows AppFabric caching service. We wanted to include these features in the official 1.5 release, but the time was running short. And so we decided to include them in the first service release. Cheers!

Released CozyRoc SSIS+ 1.5 SR-1 (1.5.101.0). The release includes the following major changes:

• New: Dynamics AX Connection manager.
• New: Dynamics AX Source component.
• New: Dynamics AX Destination component.
• New: Distributed Cache Connection manager.
• Fixed: FTPS Connection Manager failed to send QUIT command at session end when using new backend.
• Fixed: Various fixes in Database Partitions Task (Thank you Suhail).
• New: A new option Filegroup in Database Partitions Task, when using “Create Partition” action.
• New: A new option PartitionKeyNext in Database Partitions Task, when using “Insert Partition” action.
• Fixed: Dynamics CRM Destination component failed to create entity, when only one attribute was specified.
• New: Lookup Plus component now supports SQL statement from variable.
• Fixed: Table Difference component was dependent on .NET 3.5 framework after the new string comparison options were introduced. The component now requires only .NET 2.0 framework.
• Fixed: Excel Connection Manager failed to open password-protected Excel 2007 files.
• New: Dynamics CRM Destination component now provides newly created records identifier.
• Fixed: Excel Source Plus component did not activate selected worksheet at runtime.
• New: Zip Task now sets the target file modified date to match the source file, when CompressionType is File (Thank you, Peter).
• New: Excel Task now supports “Set password” action.
• New: Lookup Plus component now supports binary array as key.
• New: Salesforce Destination component now supports setting object fields to NULL.
• New: Lookup Plus component now supports SSIS expressions in the query statement.
• Fixed: Fixes in Dynamics CRM Source component to support Dynamics CRM 2011.

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

• Fixed: ODBC Destination component didn’t process decimal columns properly in MySQL database (Thank you, Romeo).
• Fixed: Zip Task failed with “Could not find a part of the path…” error when trying to decompress Tar archives containing folders.
• Fixed: OpenPGP Task failed with “Cannot access closed file.” error when specified target was variable containing in-memory stream object.
• Fixed: DB2 Destination component was not able to process properly columns with NULL values in specific situations (Thank you, David).
• Fixed: ODBC Destination component failed with “Unable to cast object of type ‘Microsoft.SqlServer.Dts.Pipeline.BlobColumn’ to type …” error when input column was of type DT_BYTES, DT_IMAGE, DT_TEXT or DT_NTEXT (Thank you, Allen).
• Fixed: Salesforce Destination component failed with “… is not valid for the type xsd:double” when used in international environment (Thank you, Blazej).
• New: Table Difference component now includes more options for string comparison (Thank you, Shane).
• New: Salesforce Destination component now provides newly created records identifier (Thank you, Sam).
• Fixed: Salesforce Source component failed with “INVALID_TYPE: sObject type ‘…’ is not supported.” error when processing certain SOQL statements containing relationships (Thank you, Ben).
• New: A new option “Address and city separated by newline” in Address Parse component. The new option permits explicit separation of address and city elements (Thank you, Richard).
• Fixed: Execute Package Task for SQL Server 2008 failed with “Error 0×80080005 while loading package file … Server execution failed.” error when ExecuteOutOfProcess option was used (Thank you, Paul).
• Fixed: Script Component Plus failed with System.MissingMethodException error when using SQL 2008R2.
• Fixed: Zip Task included the full path of specified input files when using Tar packages.