Blogs

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

• Fixed: FTPS Connection Manager was not able to parse file information provided by Connect:Enterprise UNIX FTP server.
• Fixed: SFTP Task will now return error, when there are no remote files to receive or remove. This matches the behavior of the standard FTP task.
• Fixed: Zip Task failed with error "Cannot access a closed file" when decompressing File.
• Fixed: SSH Connection Manager failed to connect to servers requiring both key file and password for authentication (Thank you, Jeremy).
• Fixed: When connected to GlobalSCAPE Server SSH Connection Manager failed with "inputstream is closed" error message, trying to retrieve directory list with more than 250 files.
• Fixed: Data Flow Source was not able to locate a Data Flow Destination, when the Data Flow Task was contained in For Each Loop container (Thank you, Miguel).
• New: FTPS Connection Manager can now process remote file list containing only names.
• Fixed: When Data Flow Source / Data Flow Destination were used multiple times in a package, the execution failed sometimes with message: "The component ... was unable to process the data".
• New: A new option skipNewline in EDI Source configuration file for avoiding formatting carriage return / line feed characters.
• Fixed: Package Connection Manager retrieve of related Package object is now more robust.
• Fixed: Jabber Connection Manager crashed when used with invalid parameters.
• Fixed: Data Flow Task Plus was not installed properly on 64bit systems.
• Fixed: OpenPGP Task failed to encrypt signed package output as ASCII.
• New: Included new licensing system and related support services. Now customers can request trial keys, request license keys for their purchases and automatically renew subscription license keys all without assistance from CozyRoc support team. You can find more details about the new system in our licensing instructions.

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

• Included validation in DB2 Destination component, when numeric column is not large enough to accommodate input column.
• Included support for extraction from multi-volume Zip archive in Zip Task.
• Fixed: Zip Task, SFTP Task and Amazon S3 Task didn’t process correctly wildcard specified source.
• Included more validation for source and target package variables in Zip Task.
• Fixed: Zip Task incorrectly created target file when decompressing from Zip or Tar archives.
• Fixed: When streaming data cross-task, the stream was incomplete sometimes.
• Fixed: FTPS Connection Manager was not able to transfer files in implicit mode with FileZilla Server.
• Fixed: FTPS Connection Manager was not able to parse Unix file information with missing file group field.
• Included support for processing multiple source wildcard file specifications in Zip Task and SFTP Task. Each specification is separated with vertical bar (|).
• Fixed: SFTP Task will now return error, when there are no files to send. This matches the behavior of the standard FTP task.
• Fixes in Data Flow Task Plus.
• Included support for processing multiple items (string or IFileInfo) in SFTP Task for remote parameter, when using "Receive files", "Delete remote files", "Get remote files list" actions. The remote parameter has to be variable of type Object.
• Changed install/uninstall options to be available to all machine users.
• Fixed: FTPS Connection Manager failed to complete download when downloading 30MB or larger file to a network share (Thank you, Tom).
• Fixed: When connected to wu-2.6.1 server, the FTPS Connection Manager incorrectly included sub-folder files as part of specified folder list (Thank you, Amrit and Team).
• Fixed: Help command was not functioning properly after installation of SQL Server 2005 SP3.
• Changed to display with message box the licensing errors, instead of failing unlicensed package execution.

We wish all our customers and prospective customers Happy New Year 2009. We have great plans for this year so stay tuned!

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

• Fixed: Oracle, DB2 and Informix destination components validation was incorrect.
• Fixed: FTPS Connection Manager didn't parse all remote file date/time formats of Unix-based servers.
• Fixed: FTPS Connection Manager constructed incomplete remote file names.
• Fixed: Zip Task's RemoveSource option didn't work properly when compressing single file.
• Fixed: OpenPGP Task now includes additional encryption algorithms.
• Fixed: Oracle Destination component failed with NullReferenceException error, when trying to bulk-insert columns with NULL values.
• Fixed: FTPS Connection Manager failed to disconnect from server (Thank you, Mika).
• Improved validation of Zip Task target parameter when selected action is Decompress.
• Fixed: Stream Task's Transfer Stream failed with NotImplementedException error, when used as a source in SFTP Task.
• Improved EDI Source component. It can now match segments by specifying a regular expression in segcode configuration parameter. Also the sub-segments data flow outputs now include the parent segment fields.
• Included SQL 2008 upgrade manifest. Now the upgrade of SQL 2005 SSIS packages to SQL 2008 is a breeze.
• Included support for keyboard-interactive mode of authentication in SSH Connection Manager.
• Included more diagnostic information.
• Included support for OTP S/Key MD4 MD5 password protection in FTPS Connection Manager.
• Included option to include the data when creating a signature with OpenPGP Task.
• Included option to handle and encrypt OpenPGP signed data in OpenPGP Task.
• Fixed: OpenPGP Task did not display public keys, used both for signing and encryption.
• Included 64 bit installations for SQL 2005 and 2008.

We have published a couple of SSIS scripts recently. We are sure you will find them useful. This is the list:

• Timer Task - provides ability to delay package execution for specified amount of seconds.
• Transform XML Task - transforms XML document, using specified XSLT configuration file.
• Find And Replace Task - search for text or search for text and replace with another text.
• SQL Job Agent Task - provides basic SQL Agent Job manipulation operations.

A message from Stacy Dimitrova, Vice President - Sales CozyRoc LLC

It's our 2nd Anniversary this November and I'd like to thank you for all your support. We couldn't have done it without you!

CozyRoc started as an exciting project of a couple “young” professionals. They had been building business intelligence and data warehousing products for over 30 years combined experience. As we were growing up, we were making sure that our clients receive a product that is the best they could get in the industry. It combines great functionality and value. We also made sure our customer support and service are outstanding. Most of our clients will agree, the live chat & instant messaging gave them one more good reason to choose CozyRoc. Many service questions and requests were answered in less than 6 business hours.

We now live in an ever-changing economy and the downturn is painful for everyone. I am happy to share that in these conditions our clients are recognizing even more the value of CozyRoc components, as they give greater flexibility and won’t hurt your budget.

In recognition of the people who have trusted us for the past two years, I would like to say: CozyRoc is here to stay! We like to do business with successful companies and we will help you be even more successful. We know how to get the job done right and we will back our products and services the same way we have done in the past. We stand proud behind our slogan: Cozy Service...Rock Technology!

Happy Birthday CozyRoc!

Ivan Peev’s article about SSIS scripts has been posted on MSDN.

Check it out here: http://msdn.microsoft.com/en-us/library/dd129901.aspx

It contains good introductory information about setting up and creating SSIS scripts. You will also find valuable information how your SSIS scripts can be boosted with CozyRoc’s enhanced Script Task Plus. There is one piece of missing information worth mentioning: the article describes the scripting in SQL Server 2005. A similar Script Task Plus is available for SQL Server 2008 as well. Enjoy!

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

• Implemented support for FTP w/ USER proxy type in FTPS Connection Manager.
• Fixed: FTPS Connection Manager did not process Windows FTP server files correctly.
• Fixed: Crash when creating data source in BIDS.
• Fixed: FTPS Connection Manager did not report IO errors (Thank you, Dan).
• Fixed: EDI Source component did not process sub-segments properly.
• Fixed: FTPS Connection Manager was not able to connect to certain FTP servers, returning error: No such host is known.
• Implemented support for FTP over TLS in FTPS Connection Manager.
• Fixed: FTPS Connection Manager failed to parse date/time of remote files, when local machine culture was other than English.

We have published a script to retrieve property of Analysis Services object like server, database, cube or dimension. Enjoy.

The blog system is now hosted on the main site. The previous information is still available at wordpress.