CozyRoc's blog

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: PGP 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 PGP Task.
• Included option to handle and encrypt PGP signed data in PGP Task.
• Fixed: PGP 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!

CONTEST ANNOUNCEMENT - Celebrate COZYROC anniversary and win some cool prizes too.

CozyRoc is having THE FIRST SSIS SCRIPT CONTEST, starting November 10, 2008 until January 31, 2009. These are the rules and the prizes:

RULES: The script input and setup must be user-friendly, which implies that you have to use CozyRoc Script Task Plus user interface extensions. The scripts will be judged based on the value and solution they provide to real problems. The greater value it delivers to a broader audience, the higher its chances are. By submitting your script, you give CozyRoc full rights to it. Check script repository for inspiration and ideas.

Submit your original script to: contest@cozyroc.com, between 11/10/2008 and 01/31/2009. We will announce the winners in the first week of February 2009. The most interesting scripts will be posted on our website for everybody to see.

PRIZES:

1^st prize: $250 gift certificate from BestBuy store.

2^nd prize: $100 gift certificate from BestBuy store.

3^rd prize: CozyRoc T-shirt.

Let your imagination flow! Ready, Set, Go!

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.