We have upgraded our web site to a new content management system. Please report if you encounter problems. Enjoy your stay.
April 8, 2008
February 26, 2008
Released CozyRoc SSIS+ 1.2 SR-1
Released CozyRoc SSIS+ 1.2 SR-1 (1.2.101.0). This release includes following major changes:
- Implemented new action in the SFTP task for retrieving list of remote files.
- Fixed Zip Task. It always created Zip64 archives, even when not needed.
- Fixed Database Partitions Task:
- Create Partition action failed with “Specified cast is not valid.” error message for certain partitioned tables.
- Insert Partition action failed with “Cannot insert explicit value for identity column in table ‘…’ when IDENTITY_INSERT is set to OFF.” when partitioned table contained identity columns.
The SQL 2008 version is also updated.
January 20, 2008
Released official CozyRoc SSIS+ 1.2
We have great news. We have just released CozyRoc SSIS+ 1.2 library and our newer pricing structure. Greetings to Stacy, George, Bobby and Andy.
December 17, 2007
CozyRoc SSIS+ 1.2 Beta 2 Released
We are announcing with great pleasure the release of CozyRoc 1.2 Beta 2. It includes one very cool new component called Data Flow Task Plus. As you may have guessed from the name, it is an extension of the standard Microsoft Data Flow Task. When we started planning for the next version, we determined there are places where SSIS framework can be improved. One of those places was the data flow task, with the inability to reuse the logic in it in other packages. What we determined was needed, sounded daunting at first and believe me, our accomplishment so far is nothing short of amazing. What this new component is now giving you is the ability to componentize and reuse your data flow logic in other packages and lets you keep track of the changes separate from specific package. In addition to that we have implemented a customizable user interface for your data flow, so when you decide to distribute your shiny-dandy data flows to other users, they will not be required to check what is going inside, but just point-and-click the parameters to setup the task for the new job. Now you will probably realize how important were the Data Flow Source and Data Flow Destination components to allow complete abstraction of your data flows from specific package and achieve top performance.
This release includes also the following major changes:
- SSH Connection Manager component.
- Fixed connection manager. Sometimes it failed with ‘Value cannot be null’, when working against freeftpd server.
- Script Task Plus component.
- Implemented to initialize script from task-scoped SSIS variables. The new approach is better suited for package configuration. ScriptInit property should not be used and is depreciated.
This new version is great news and great holiday gift for powerful SSIS users and we will be glad to hear your opinion about it. Gives us a shout and let us know what you like and what else do you think is needed. The release is available for download here.
November 1, 2007
CozyRoc SSIS+ 1.2 Beta 1 Released
It is November 1 and a perfect day to announce Beta 1 of CozyRoc SSIS+ 1.2 library. We have included some really powerful components, which will serve as foundation for other advanced components:
- Package SSIS Connection Manager – Provides access to the current or different package at runtime.
- Data Flow Source SSIS Data Flow Component – Very fast, non-blocking, in-memory data read from another data flow.
- Data Flow Destination SSIS Data Flow Component – Exposes data from a data flow for in-memory read in another data flow.
We will soon blog about the performance of these new components. Our preliminary tests show they match the performance of the raw data file source/destination components, but there is one important difference. Our components do not need to go thru intermediate file write/read step. They are reading/writing in parallel and the process is not sequential as the Microsoft recommended solution for transferring data from one data flow to another. You can try it for yourself by downloading the package.
And of course the new release is available for download here.
September 23, 2007
Public SSIS script repository now with support for “wanted”
We have included a new feature in the script repository. If you need help in your SSIS project, you may post a request for a script and let the community assist you.
September 9, 2007
Finally a central public repository for your SSIS scripts
We are happy to present a public repository, which is strictly for SSIS scripts and functionality. If you are existing user of SSIS+, you can immediately start sharing your magic with the rest of us. If you haven’t heard about SSIS+, now is the time to find about it and how it can improve your productivity.
Released CozyRoc SSIS+ 1.1 SR-2
We have released SR-2 of SSIS+ 1.1 library.This release includes following major changes:
- New attributes:
- SortProperties attribute allows definition of custom display order for parameters.
- FilterProperties attribute allows dynamic filter of displayed parameters.
- ValidateProperties attribute allows validation of parameters.
For more information please check Script Task Plus documentation. - Fixed crash when script was edited for the first time and was not manually compiled.
Fixed deadlock in user interface after executing the task.
More announcements are coming…
August 31, 2007
Released CozyRoc SSIS+ 1.1 SR-1
We have released SR-1 of SSIS+ 1.1 library. It includes additional option for authentication in SSH Connection Manager with private key file/passphrase. Please check the documentation or download it.
August 15, 2007
Released official CozyRoc SSIS+ 1.1
We are happy to announce the official release of our SSIS+ 1.1 library. We hope you will find the components we have built useful for your SSIS workflow. We would like to thank Stacy, George, Krasi, Tamir and Matthew making this release successful. Enjoy
