It would be much easier to help if you'd provide the table schema and sample data in a readily-consumable form.

Here's an exmple of how to post sample data...

Do all of the files have the same format? If so, you'll only need one file connection. You can use a For Each loop container to loop through...

An alternate workaround could have been to replace the table in the DSV with a named query and used the CAST funtion inside the query. I chose to change...

OK, so I've found that this is a bug. The bug was reported quite a while back and there appears to not yet be a fix for it.

When you...

Really, nobody has seen this before or has any insights into what I'm seeing?

C'mon folks!!

I agree. Getting the data from the OLE DB source component here may be better. Typically, the source data is comming from a seperate system then where you...

That's where I was going to go with this too Jeff, the ANSI JOIN syntax. I wanted to see the table structure though because I noticed that the join...

You'll need to be careful with #1. SSIS is very metadata dependant and a stored procedure that returns a different result set based on parameter values can cause problems....

If the SP logic is not something that you can dulicate inside a data flow, I would suggest backup up and using the For Each Loop container with an Execute...

Ah, I didn't see that. OK, I just wanted to see if that was being accounted for. It seemed like we were on different pages there for a...

Elliott W (9/22/2009)

---

Ok, here is a really quick and dirty POC. How many Dataflows run depends on the variable "ExecutionThreadCount", it can be up to 5. I even...

Can you post your table DDL for customer and address and include the index definitions?

Even w/ multiple data flows, the challenge is still to have each data flow work on a distinct subset of the data. If you have 100 rows that need...

Here's an example of getting the plan into the forum thread.......

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Elliott W (9/22/2009)

---

John Rowan (9/21/2009)

---

It may be possible, but the only way I see it working would be for you to dynamically create data flow tasks based on your...