Solved

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

Posted on 2011-09-19
3
337 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:
huslayer 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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

743 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

12 Experts available now in Live!

Get 1:1 Help Now