You don;t need to use sequence containers for this. You must have connected your tasks together in the wrong order i.e. you had the arrow head pointing to theExecute SQL Task instead of pointing to the Data Flow TaskJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings MC ID: Microsoft Transcript Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

You don;t need to use sequence containers for this. You must have connected your tasks together in the wrong order i.e. you had the arrow head pointing to theExecute SQL Task instead of pointing to the Data Flow TaskJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings MC ID: Microsoft Transcript Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

You don;t need to use sequence containers for this. You must have connected your tasks together in the wrong order i.e. you had the arrow head pointing to theExecute SQL Task instead of pointing to the Data Flow TaskJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings MC ID: Microsoft Transcript Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

Hi There - Please take a look at the following articles to learn more about Precedence Constraints in SSIS: http://www.simple-talk.com/sql/ssis/working-with-precedence-constraints-in-sql-server-integration-services/ http://msdn.microsoft.com/en-us/library/ms141221.aspx http://blogs.msdn.com/b/mattm/archive/2006/10/30/using-expression-based-constraints.aspx Best Regards, Datta ---------------------------------------------------------------------------------------------------- Dattatrey Sindol My Blog: Datta's Ramblings on Business Intelligence 'N' Life The information provided here is "AS IS" with no warranties, and confers no rights. Please mark the post as answered if it solves your problem.

I've got two tasks. The first is an execute SQL task and the second is a data flow. It runs the data flow first, then the SQL task. This is backwards. Deleting the arrow and replacing it didn't help anything. What's the mystery to this?

Can you share a picture of that?Arthur My Blog

Don't know how to do that. Anyway I put the tasks in separate sequence containers and it runs in the correct order now.

Use the rightmost button that looks like an image with a plus sign There must be no need for what you have done. Arthur My Blog

You don;t need to use sequence containers for this. You must have connected your tasks together in the wrong order i.e. you had the arrow head pointing to theExecute SQL Task instead of pointing to the Data Flow TaskJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings MC ID: Microsoft Transcript Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker