News

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.

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,

Hello,
I try the table partition task and I have a question. When I select
the action, it shows the target and the partition table.
Problem is that I cannot type nothing in the target field and if I
click the arrow, it shows a blank list.
I tried two connections, oledb and ADOnet
What am I doing wrong?

Steve,

I have sent you a personal email, with a test package demonstrating
the functionality. The issue reported by Andy was a different one and
we determined it was "by design" behavior of the SSIS framework.

Regards,
Ivan

I switched to using a File and not a variable, then had this file have
its connection set dynamically in a expression. This did not work. I
then called the dts.connections("fileName").aq uireConnection(Nothing)
to reset it prior to the task firing and this still didn't do
anything.

Let me know if anyone has any ideas.

Ok, the Zip task doesn't seem to be taking the variables you pass to
it as the file name source or the destination if you are changing the
variables inside the package. Example if you are running the Zip task
inside a for each for a directory and passing it the file name it
never gets off the first file name you set as the variable default.

Hi Philippe,

Thank you for reporting these issues. The typo fix will be included in
the next SR. The three "box" control chars are supposed to be
invisible "Tab" chars, but because of a bug in the .NET framework they
do not appear correctly. Please upgrade to the latest .NET 2.0 release
and I believe they should go away.

Hi,
I note that there is a typo in the zip task "decomress" instead of
decompress, it also has three "box" control chars before the word
General.
I also had quite a few problems with your web site, i.e. when I
cliqued on the zip task image to read the details, I have got a bad
runtime error message that did not want to go away. I also came across

Just posted Beta 1 of CozyRoc SSIS+ 1.3 . The release includes new components for public-key cryptography encryption using OpenPGP standard, components for connection with Amazon S3 service and components for bulk-loading of data in the major databases on the market: Oracle, DB2, Informix. Your feedback is greatly appreciated.

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]