News

Fri, 08/27/2010 - 08:44

updated Readme 1.5

Before I look too much further at this product I wanted to make sure
you can do tunneling and port forwarding with it. Would I be able to
do something comparable to "ssh -L <port>:<host>:<hostport>" with this
product?

Hi Nitesh,

I have sent you a personal message and I'm still waiting for your
reply. Let me know if you still need our assistance.

Regards,
Ivan

Hi,

We recently purchased the license for SSIS+ 1.4, earlier we were using
1.3. The Zip task now behaves abnormal. It sometimes run and sometimes
fails. It gives the error as Invalid target.

Any help would be appreciated.

Thanks,
Nitesh

Michael,

The script has been updated to use the latest Google Client 1.6.0.0

Regards,
Ivan

Hi, I am trying to get the google components from the script + ssis
component to work running the 1.4 version of cozyroc. I have installed
the API, and deployed the google.gdata.client assembly to the gac
using gacutil -i in my .net sdk stuff. I am now trying to use the
script to pull from analytics, and I get this error:

I recently attempted to upgrade SSIS packages containing a really old
TableDifference control (from sqlBI days). The techical support at
CozyRoc was outstanding and I just wanted to mention briefly what
worked.

Originally, the error(s) I received were:
Error 0xc00490f7: MyTaskName: The managed pipeline component

Tim,

I can assist with your inquiry. Try to restart your SSIS service. If
it doesn't help you may have to restart your machine.

--
You received this message because you are subscribed to the Google Groups "CozyRoc" group.
To post to this group, send email to cozyroc@googlegroups.com.
To unsubscribe from this group, send email to cozyroc+unsubscribe@googlegrou ps.com.

When I try and run a package from BIDS that has a FTPS connection
defined I get a error box that pops up saying [Packag Name]: The
object invoked has disconnected from its clients. Do you want to
terminate them instead?

This only happens when i have this connection type added to my
connection managers.

Hi,
What do you mean by "strip off attachments" ? Do you want to download
email attachments?

Has anyone used Cozyroc to read MAPI/Exchange emails and strip off
attachments?

Thank Ivan. I'm using SSH primarily. Some of the vendor servers I
connect to seem to have some problems at times, and I always end up
having to resend things. If I could log these failures and send them
to the vendors, I could probably get some things fixed. Sorry I've
been so tardy, I guess my email notifications haven't been coming

Hi,
I have checked the serialization and your guess was correct. Only base
types can be serialized string, int32 , etc. Your custom object should
serialize to/from string. The Script Component Plus has no way to know
how to serialize the custom object. The custom property is itself
stored in the SSIS package, which as you know is one big-long XML text

Can you send a sample package with the script to supp...@cozyroc.com ?

I've made some headway with developing a custom UI + custom windows
form for a dataflow script property, however I've hit a roadblock when
it comes to saving + accessing that property.
Can you have a custom object/class with various properties, and then
save that as a property against a dataflow script? or do you need to

1. If the shared script file doesn't exit, the task will fail.
2. Yes, you can use an expression to setup the path to the shared
script file. The path is contained in the ScriptLink property.
3. The property value is stored as variable and the context is the
task. The variable is named _<PropertyName> If you have a new property

CozyRoc SSIS+ 1.5 is now officially ON. The last few weeks were primarily devoted to make CozyRoc’s Dynamics CRM integration more robust and work properly in different business scenarios. We would like to extend our great appreciation to Mike Prieskorn for his tremendous assistance and patience beta testing the new CozyRoc CRM components. Thank you, Mike!

Summary of the products available immediately for purchase:

• SSIS+ Ultimate Subscription at $399.95/Year
• SSIS+ 1.5 perpetual license at $1,399.95
• USPS Address Database / One time purchase at $299.95
• USPS Address Database / Monthly Subscription at $2,399.95/Year
• SSIS+ Premium Support at $499.95/Year

For more information, check the purchase page.

Summary of the new / updated components

• Dynamics CRM Source – Load data from Dynamics CRM service.
• Dynamics CRM Destination – Store data to Dynamics CRM service.
• Dynamics CRM Connection Manager – Connections with Dynamics CRM service.
• Send Mail Task Plus – Enhanced send mail with support for secure emails.
• Receive Mail Task – Receive emails from POP3 and IMAP servers.
• SMTP Connection Manager – Connections with SMTP email servers.
• IMAP Connection Manager – Connections with IMAP email servers.
• POP3 Connection Manager – Connections with POP3 email servers.
• SSH Connection Manager – New SSH backend with new features.
• FTPS Connection Manager – New FTPS backend with new features.
• Excel Source Plus – Enhanced loading of data from Microsoft Excel with 64bit support.
• Excel Destination Plus – Enhanced storing of data to Microsoft Excel with 64bit support.
• Excel Task – Simplified management tasks for Microsoft Excel.
• Excel Connection Manager – Connections with Microsoft Excel workbooks with 64bit support.
• SharePoint Source – Load data from Microsoft SharePoint service.
• SharePoint Destination – Store data to Microsoft SharePoint service.
• SharePoint Connection Manager – Connections with Microsoft SharePoint service.
• Parallel Loop Task – Concurrent execution of SSIS loops.

yeah, I'll give it a go. Don't expect to hear from me for a few months
though, as there's a fair few other (non-ui) scripts to write.
but if I do succeed, I'll post it in the shared samples.

CozyRoc have just released SSIS+ 1.5 Beta 2. There is one major new task included. It is called “Parallel Loop Task“ and as the name implies it provides ability to execute multiple iterations of the standard Foreach Loop Container concurrently. In tests, a CPU intensive sequential process when executed in parallel on 4-core machine was executed 3 times faster compared to the sequential. You can literally improve the execution speed of your packages by simple upgrade of your server hardware.

Another important addition to Beta 2 is the inclusion of support for Dynamics CRM 3.0 systems. Now you can use the same integration technology from CozyRoc for both your legacy and newer systems.

As always your feedback is greatly appreciated.

Interesting.....
What happens if the modified file in the shared location is moved?
Will the job just fail?
Can you set the path to the STX file as an expression?
What happens if the STX file is altered to add in new (optional)
properties? e.g. if a new property is added, but not required, will
the existing packages using the script still process successfully?