Solved

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

Posted on 2011-09-19
3
348 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Is Your DevOps Pipeline Leaking?

Is your CI/CD pipeline a hodge-podge of randomly connected tools? You’ve likely got a tool to fix one problem & then a different tool to fix another, resulting in a cluster of tools with overlapping functionality. Learn how to optimize your pipeline with Gartner's recommendations

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

726 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