After some trial and error I found a partial answer to my problem. The package I was calling was a parent package. If I called the child packages...

What edition of SQL Server is this available with?

We are using data flows where the source is a SQL command. The queries have been gone over with several times to make sure that they using the right...

The queries don't have parameters.

One of the queries did have two CTEs. When we rewrote the query using derived tables instead of the CTEs we didn't get the CXPACKET...

Any luck with this? I have to do something similar.

Yes, removing the TABLOCK did help performance.

My question though is still: does it matter if you have the same table being loaded by 12 different flows simultaneously or should the...

The data I provided was just an example to make the point. I am very familiar with the T-SQL solution suggested and use it frequently. 🙂 ...

Sabya,

Thanks for the links. It is actually Rafael Salas' solution that I was trying to implement.

After some more poking at my package I got this error message:

Warning loading <PackageName>...

I am trying to use the package configurate type of sql server.