Forum

Syndicate content
This is a newsgroup for discussing CozyRoc family of products. Enjoy.
Updated: 22 hours 5 min ago

SSH Tunneling

Thu, 09/09/2010 - 04:00
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?
Categories: News

Re: Zip Task SSIS+ 1.4

Thu, 09/09/2010 - 04:00
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

Categories: News

Zip Task SSIS+ 1.4

Thu, 09/09/2010 - 04:00
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

Categories: News

Re: Cant get the google script components to work

Thu, 09/09/2010 - 04:00
Michael,

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

Regards,
Ivan

Categories: News

Cant get the google script components to work

Thu, 09/09/2010 - 04:00
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:
Categories: News

Hints for upgrading from SSIS 2005 to 2008 - Table Difference control

Thu, 09/09/2010 - 04:00
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

Categories: News

Re: FTPS Connection Error SSIS 2005 ver 1.4.102

Thu, 09/09/2010 - 04:00
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.

Categories: News

FTPS Connection Error SSIS 2005 ver 1.4.102

Thu, 09/09/2010 - 04:00
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.

Categories: News

Re: MAPI Email attachments

Thu, 09/09/2010 - 04:00
Hi,
What do you mean by "strip off attachments" ? Do you want to download
email attachments?
Categories: News

MAPI Email attachments

Thu, 09/09/2010 - 04:00
Has anyone used Cozyroc to read MAPI/Exchange emails and strip off
attachments?
Categories: News

Re: SFTP File Transfer Session Info

Thu, 09/09/2010 - 04:00
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
Categories: News

Re: Dataflow script component + custom object properties

Thu, 09/09/2010 - 04:00
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
Categories: News

Re: Dataflow script component + custom object properties

Thu, 09/09/2010 - 04:00
Can you send a sample package with the script to supp...@cozyroc.com ?
Categories: News

Dataflow script component + custom object properties

Thu, 09/09/2010 - 04:00
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
Categories: News

Re: STX runtime

Thu, 09/09/2010 - 04:00
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
Categories: News

Re: Dataflow tranformation with selective column inputs

Fri, 08/20/2010 - 04:00
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.
Categories: News

Re: STX runtime

Fri, 07/23/2010 - 04:00
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?
Categories: News

Re: SFTP File Transfer Session Info

Wed, 07/14/2010 - 04:00
Which connection manager do you use? SSH Connection Manager or FTPS
Connection Manager?
Categories: News

SFTP File Transfer Session Info

Wed, 06/23/2010 - 04:00
I've looked at some of the demo code for the SFTP control. I really
need to be able to see file transfer session info. We always have a
lot of trouble sending data to a particular vendor. Does the SFTP
control give me access to any of the session level negotiation that
takes place? You know, stuff like "connecting", "connected",
Categories: News

Re: STX runtime

Wed, 06/23/2010 - 04:00
The modified file from the shared location will get loaded at runtime
if you are "linked" to the script. If you break the link (press the
button again), the script will no longer load from the shared
location.
Categories: News

PASS Summit '10

November 8 - 11, 2010 Washington State Convention & Trade Center in Seattle, WA

CozyRoc will be exhibiting at the Premier Conference for SQL SERVER Professionals. Visit CozyRoc at booth #425 and say HI. Register with code CR3D and get $100 off.

CozyRoc SSIS+ has been nominated for the 2010 SQL Server Magazine Community Choice Awards, category "Best Business Intelligence & Reporting Product". Vote Now to help us win this prestigious award.