Forum

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

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.

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?

Which connection manager do you use? SSH Connection Manager or FTPS
Connection Manager?

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",

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.

quick question - if you link to an stx file (i.e. in the script task
plus, or script component plus), will that linked file get loaded at
runtime, or will it only change at design time?
e.g. if I create a solution, and link to a common script (e.g. "move
files" or similar). I then deploy this as a SQL agent job. If I modify

Hi,
There is Windows 7 x64 compatibility issue. The instructions how to
fix it manually are posted in the FAQ page: [link]

I accidentally installed the 32-bit version of the control on my 64-
bit machine. I realized my mistake and uninstalled SFTP. Now I can't
load BIDS. At startup, BIDS generates an error about not being able to
load clsid {aa40d1d6-caef-4a56-b9bb-dod3d c976ba2}. The error number is
800700C1.
Dev Environment is Win7 64 / VS2008

It doesn't use existing UITypeEditor. FolderEditor is implemented in
the script. Check the top of the script.

Yeah, I have read the link however that utilizes an existing .Net
UITypeEditor.
I haven't developed a usercontrol in a while, let along a
UITypeEditor. It'll take me a while to figure out how to use / call it
with a custom form.

Check the link with the sample I have sent in my previous message. It
contains answer to the exact question you are asking on how to open
property editor with custom Form.

Unfortunately my programming experience has mainly been data focused,
not UI. So i'm a bit rusty on the winforms controls.
If I could get an example of how to call a custom windows form as a
property editor, I could certainly do it and release it as a sample
script. Can you just open the script task in the IDE, click "Add

Well, the best solution would be the hardest to implement (would
require custom logic to handle). And btw you can implement any type of
user interface for the SSIS script task. You may check the following
script for reference:
[link]
Take a look at the FileFolder property. It has an editor defined in