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
This release is really about a new component called SSH Execute task. It allows secure execution of shell commands on a remote SSH server. Enjoy!
We are getting very close to our official release of SSIS+ 1.1. The new release includes improvements to CozyRoc Zip Task validation and 2 new components:
* CozyRoc SSH Connection Manager - provides support for secure SSH connections and has proxy support.
* CozyRoc SFTP Task - with support for send, receive and delete files, create and remove directory, rename file.
As always you can download it from here.
The new release includes CozyRoc Script Task Plus component. The new component allows greater reusability and easier maintenance of script functionality. It has the following features:
You can download it from here. Requires SQL Server 2005 SP2.
If you are interested in SSIS project deserialization, here is a brief summary of the steps you need to follow to install your own deserialization routines (please have Reflector in hand because most of the details below are undocumented):
1. Make sure you have reference to the following libraries:
3. Install handler for application.Events.SelectionEvents::OnChange event.
4. Check selected item is of type ProjectExt.
5. Install your own ISettingsService service provider class. You can get access to the service container and current ISettingsService service provider with the following code:
Hierarchy projHierarchy = project.GetType().InvokeMember(
"ProjectHierarchy",
BindingFlags.GetProperty | BindingFlags.NonPublic | BindingFlags.Instance,
null,
project,
new object[] { } ) as Hierarchy;
IServiceContainer serviceContainer = (IServiceContainer)projHierarchy.GetService(
typeof( IServiceContainer ) );
ISettingsService ssOld = (ISettingsService)serviceContainer.GetService(
typeof( ISettingsService ) );
6. Override ISettingsService::GetSetting method and check:
If you have a match, you have to return a type to a dummy class whose only purpose is to provide attributes, used by the infrastructure internally. The default implementation is called PseudoPackage. Attribute your new dummy class with DesignerSerializer attribute and parametrize it with your own serialization class. It has to inherit from DtrDesignerSerializer class.
7. Override DeserializeComponent and SerializeComponent. These are the methods, which will be called for each SSIS project task during serialization. Voila! Now you are the master of the universe.
We have created a newsgroup where you can exchange ideas and make suggestions for future features in our products. If you had some crazy ideas about SSIS, bring them on. We would like to hear about them.
Just released Beta 1 of SSIS+ 1.1 . Database Partitions task is now part of a bigger initiative and our goal is to provide decent enhancements to the excellent Microsoft SSIS framework.
We have implemented a new feature called Script Task Parameters. You can check the technical details here. We want to make SSIS script tasks more powerful. The first step, which you can now see is user interface authoring. The next step in this journey will be to make the SSIS script tasks easier to package and deploy. This will reduce the need to build and deploy your own custom components for SSIS in Visual Studio 2005, avoiding the learning curve for which there is no workaround. We have some ideas and we are sure you will like the result.
Released beta 1 of CozyRoc SSIS+ 1.1 (1.1.1.0). This release includes following major changes:
Released update to Database Partitions (1.0.0.1). Includes references to online documentation.
