News

It was misconfiguration in SFTP task. I didn't specify files that I
wanted to download.

Thanks,

Hi All,

I just downloaded the CozyRoc SSIS Library and tried to implement SFTP
task. But I got an error, "[SFTP Task] Error: An error occurred with
the following error message: "not supported to get directory /
HOME/..".

I am not sure it is a task configuration issue or sftp permission
issue.

Neo,

I will need more information about what is the DB2 client and server
versions. Also what version of SQL Server do you use? SQL 2005 or SQL
2008? The DB2 Destination component requires installation of IBM Data
Server Runtime Client version 9.5 .

One more thing. I will need more information about the data type of

Hi all,

I installed cozyroc 1.3 and used the DB2 destination component. Before
using this, I was using an OLE DB Destination to insert data to DB2
and it was taking almost 3.5 hours to insert 1.4 million records.

But on replacing OLE DB destination with DB2 Destination I am getting
an SQL error dump and the package execution remains in yellow stage

Hi Philippe,

Yes. It was fixed in SSIS+ 1.2 SR-3. And BTW it was reported by
Nicholas. I'm sorry for inconvenience. The problem was caused by our
library VS add-in. It is now resolved.

Regards,
Ivan

Hello,
The Microsoft SSIS forum post attached bellow describe a problem when
accessing AS partitions in BIDS as well as the identified solution
which consist in installing Cozy Roc V1.3 in replacement of V1.2 which
causes the bug.

[link]

Hi Tim,

The evalutation of connection manager expression is a little bit
tricky. The way Microsoft designed it is to evaluate expression after
a client of the connection manager calls '<Connection
Manager>.AcquireConnection' method. I'm not sure what is the exact
setup of what you are trying to accomplish, but if you send me a

I am trying to use sftp and use a keyfile/passphrase for my
connection. On ssh connection manager I have tried populating
serverpassword with an expression. It appears conenction manager is
not using this variable because I keep getting Auth cancel
(Tamir.SharpSSH).

I am able to test the connection in the foreground successfully. What

This post is related to:
[link]

To anyone with a similar issue, we have created a sample SSIS package
with variable iteration implementation. It includes the following
elements:

1. For Loop Counter container, iterating counter variable from 1..3

Thiru,

Please check our FAQ at [link]

Check the solution under: "Why do I get the following error when
executing a package under Win64?"

Regards,
Ivan

Hi Ivan,

I am Thiru from CSC chennai.

I am using SFTP task in my project and i have developed two
packages using your SFTP task.

Working fine in BIDS and Package Utility and Agent job in my DEV
server.

When i try to run the package through BIDS and Package Utility it
is running fine but it it not running through SqlAgent job in QA

Hi Stu,

Have you checked our FAQ article over here: [link]
?

Search for "SQL Server Agent Job". You may have to change the
encryption type you use for your SSIS package because the default one
doesn't work at all. There is also a material here:
[link]

Hello again, I just tried running the package that works when run
directly from SSIS as part of a SQL Agent job. The job fails to run. I
have been having this trouble when running packages that include tasks
that run sftp .bat file executables, and was hoping that CozyRoc would
solve this problem. -Stu

Hello, I downloaded CozyRoc SSIS+ 1.2 today to determine whether it
would meet my needs for running sftp tasks in SSIS packages under SQL
Server Agent scheduler control. I was able to easily connect up to one
computer running ssh, and the sftp file transfer worked perfectly. I
was unsuccessful however connecting with a second server that is also

Philippe,

We have recently fixed an issue where Zip task always created Zip 64
archives, even when not needed (for archives less than 4GB). Please
download and install SSIS+ 1.2 SR-1 ([link]) and I
hope your issue will be resolved. Please contact us if you still
encounter a problem.

We have released Beta 5 of CozyRoc SSIS+ 1.3 . It includes small fixes to the licensing code and PGP Task. The major difference is the inclusion of Script Task Plus and Data Flow Task Plus in SSIS+ 1.3 for SQL Server 2008. We will spare you the gory details, but say it was quite challenging technical feat to accomplish. We are happy to have these powerful components as part of the soon-to-be official SSIS+ 1.3 release.

We have created a script, which simplifies the process of checking for existence of remote FTP files. You can use either SSH or FTPS connections. If the remote file exists, the result of task execution is success. Otherwise it is set to failure.

We have released Beta 4 of CozyRoc SSIS+ 1.3 . It includes a long awaited support for FTP over SSL (FTPS). The new FTPS Connection Manager supports both Explicit and Implicit FTPS connections. We have also updated the SFTP Task to include support for the new FTPS connections.

ps. Thanks for the feedback Doug.

Hello,
I am testing the Zip task.
It Works very well for both zip and unzip provided you use a local
drive, a unc or full network path does not always work well, specially
when un-zipping.
So for speed and stability, I set up the application to move the zip
file to a local folder, unzip, update the file, zip it again and move

Philippe,

This is good question. In order for you to see a table in the target
field you have to have database with a table setup as "partitioned".
The Database Partitions task will not assist you in the creation of
your partition table. It will help you to maintain a partitioned
table.

With that said, you have to first design your partitioned table,