News aggregator

We have included free classifieds repository dedicated to the community building data warehouse solutions with Microsoft SQL Server Integration Services. You can search for services or post your own classified by clicking here.

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

Released CozyRoc SSIS+ 1.2 SR-2 (1.2.102.0). This release includes following major changes:

• Implemented Data Flow Destination support a variable used to signal a waiting thread, data processing has finished.
• Various fixes in the SSH back-end component.
• Implemented SFTP task “Get remote files list” action to provide extended remote file information.
• Implemented option in SFTP task to specify if remote path is a wildcard or not.
• Fixed SFTP task to provide cleaner errors description.

We have upgraded our web site to a new content management system. Please report if you encounter problems. Enjoy your stay.

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?

Released CozyRoc SSIS+ 1.2 SR-1 (1.2.101.0). This release includes following major changes:

•   Implemented new action in the SFTP task for retrieving list of remote files.
•   Fixed Zip Task. It always created Zip64 archives, even when not needed.
•   Fixed Database Partitions Task:
  • Create Partition action failed with “Specified cast is not valid.” error message for certain partitioned tables.
  • Insert Partition action failed with “Cannot insert explicit value for identity column in table ‘…’ when IDENTITY_INSERT is set to OFF.” when partitioned table contained identity columns.

The SQL 2008 version is also updated.

Don’t waste time implementing custom data flow component events under SQL Server 2005. There is a bug, which prevents it from working. I just got back response from the SSIS PM the issue is acknowledged, but it will not be fixed in the foreseeable future for SQL Server 2005. To follow the status of this issue, track this report.

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