Hi,I have a Typical PAckage intended to daily data load into SQL Server database from various Sources mostly IBM-AS400.THe Package has almost 90 DFT's in its control flow,Even all atre simple SOurce to Destination loads with or without data conversion transfromations.My question is is it good idea to have those many DFT's in CF or should it be splitted into multiple packages?.And also I want to optimize this package..What are the possible ways /aproaches to Optimize this package?Could any one suggest??? Thanks in advanceRegards,Viha

my initial reaction would be to attempt to execute the data flow tasks in parallel (if possible). also, i doesn't make sense for the entire package to fail if only a few data flow tasks fail. thus, i suggest that you set FailPackageOnFailure = false. also see: Optimizing SSIS Package Performance Part 1 hth Duane Douglas, MCAD | http://www.ssisbi.com | Please mark the post(s) that answered your question.

MaxConcurrentExecutables will guide the control flow on how many simultaneous tasks (including dataflow tasks) to run at any one time, such as running 5 dataflows at a time, and when any one of the first set finishes, the next one will start.Duane covers this in the blog post.Thx, JasonDidn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance

Hi Viha, You have mentioned you have many data flows which are simple source to destination loads. I thought you might be interested to hear about a technology that can help. If you can use third-party solutions, check the commercial CozyRoc Data Flow Task Plus . The enhanced task includes support for dynamic data flows. You can essentially reduce the number of data flows used for transfer to only one data flow. Also, if your source table has new columns, the enhanced dynamic data flow task will pick the new columns and transfer them as well.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/