Released COZYROC SSIS+ 1.6 SR-1

Released COZYROC SSIS+ 1.6 SR-1 (1.6.101.0). The release includes the following major changes:

• New: Sybase Destination component for bulk load in Sybase database.
• New: Query Transformation component.
• New: Redesigned Dynamics GP adapters for better support of composite data.
• New: Redesigned QuickBooks adapters for better support of composite data.
• New: Redesigned Sage adapters for better support of composite data.
• New: Redesigned NetSuite adapters for better support of composite data.
• New: Dynamics CRM Destination component now supports CRM 2011 bulk-load API.
• Fixed: Dynamics CRM Source component was inefficient when retrieving from activities in system with millions of activity party records (Thank you, Allen).
• New: A new Smart Refresh supported in all COZYROC source data flow components.
• New: Script Component Plus now supports dynamic data flow.
• Fixed: Numerous fixes and enhancements in Data Flow Task Plus (Thank you, Rushabh).
• Fixed: Dynamic data flow with Table Difference component was not working properly with arbitrary input columns order. The dynamic data flow will now order the input columns (Thank you, Jasmin).
• Fixed: Dynamic data flow with error output directed toward flat file failed to process (Thank you, Leona).
• Fixed: Dynamics CRM Destination component failed with error "The maximum message size quota for incoming messages (2097152) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element." when processing large number of columns in CRM 2011 web services (Thank you, Dave).
• New: A new 'Get Partition' action in Database Partitions Task to retrieve the partition number of existing partition.
• New: A new CallerId parameter in Dynamics CRM Connection Manager for setting user impersonation.
• New: A new ExtendedRemoteFileInfo parameter in Amazon S3 Task to retrieve extended file information: size, last modified, etc.
• New: Dynamics CRM Connection Manager now supports CRM 2011 web services ActiveDirectory authentication.
• New: A new 'Rename remote file' action in Amazon S3 Task.
• New: EDI Source now setups data flow outputs only for looping segments. The previous setup logic will stay the same for existing packages for backwards compatibility.
• Fixed: Numerous fixes and enhancements in QuickBooks adapters (Thank you, Richard).
• Fixed: Dynamics AX Destination component failed with error "The supplied method arguments are not valid." when trying to process input data containing the percent (%) symbol (Thank you, Fabio).
• Fixed: Exchange Connection Manager failed with error "Value cannot be null. Parameter name: uniqueId" when retrieving list of email (Thank you, Carsten).
• New: A new InstanceName parameter in Dynamics NAV Connection Manager for setting instance.
• New: A new 'Create remote directory' action in Amazon S3 Task.
• New: A new 'Remove remote directory' action in Amazon S3 Task.
• New: A new parameter RemoteFilter in Amazon S3 Task to set remote file filter expression when using ‘Receive files’, ‘Remove remote files’, ‘Get remote files list’ actions.
• New: A new parameter LocalFilter in Amazon S3 Task to set local file filter expression when using ‘Send files’ action.
• New: A new parameter Headers in Send Mail Task to set additional mail headers.
• Fixed: Dynamics CRM Source component did not handle aliased values in CRM 2011 (Thank you, Yatik).
• New: A new parameter JobIdVariable in Salesforce Destination component to store bulk job identifier in variable.
• New: A new parameter ExistingData in Excel Destination Plus component specifying what to do with existing data - Clear, Overwrite or Append. The existing Clear parameter is deprecated.
• Fixed: NetSuite Connection Manager failed with error "Your connection has timed out. Please log in again." when trying to connect.
• New: Dynamics CRM Connection Manager now supports Office 365 deployed systems with Federated (delegated) security.