Solved

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

Posted on 2011-09-19
3
339 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Addition to SQL for dynamic fields 6 37
SSRS 2013 - Overlapping reports 2 20
SQL Improvement  ( Speed) 14 26
SSRS Enable Remote Errors 4 24
In this article I will describe the Copy Database Wizard 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 article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

776 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