Solved

SSIS move several already connected tasksfrom a for each loop container to a sequence container

Posted on 2011-09-19
3
338 Views
Last Modified: 2013-11-10
I am editing an SSIS package previously developed by another programmer.A part of this package processes files in a folder using for exch loop container and I need to add a constraint to check if the file has been processed previously, it should not be processed again. For this I added an execute sql task in the for each loop container that queries the history table and sets the value of intFileProcessed to the number of record found in that table for this file name. If the value of intFileProcessed  > 0 i do not want any other taskes in this for each loop container to execute, so I want to put them in a sequence container and connect this sequence container the my execute sql task that queries the history table with the the constraint and expression intFileProcessed  <1.

All the existing tasks (about 50 of them) are already connected, and SSIS does not let me move connected tasks in this new sequence container. Is there any other work arround?

Thanks.
0
Comment
Question by:patd1
3 Comments
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 36564825
see image
Untitled.png
0
 

Author Comment

by:patd1
ID: 36573905
I know how I can edit a precedence constraint. That's not my question. I want to maove several tasks that are already connected to each other in a sequence container, without disconnecting them (as reconnecting requires a lot of work). How can I do that?

Thanks.
0
 
LVL 21

Accepted Solution

by:
Jason Yousef, MS earned 500 total points
ID: 36574159
Nope there's no way around that, it's pain the butt, but that's the way it's, that's why the use of sequence containers or grouping is encouraged at each step.

what only you can do is to keep the tasks that you wish to move connected, and only disconnect the first one and the last one, and that's how you could move them in bulk but will lose only 2 connections  (if you're moving from the middle)  or 1 connection (if you're moving from the top or bottom)
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now