I see room for improvement here in several places.

First, you've got to use constraints and indexes in your table design. Even if you get this working, you'll...

Yes, package variables are user variables. Sorry for the confusion.

Like I said in my first reply, you'll have to set the Connection String property to embed the...

I usually default the variable values to my test DB. This allows the package to pass validation instead of failing as it does before the variables are populated.

Each iteration of your loop will grab the connection info for the current connection and set the package level variables. When the ole db connection manager is invoked during...

Why not use a data flow task?

Instead of defining expressions for the individual elements of the connection, set all of the dynamic connection properties using the connectionstring property. Here you can set server, user, password,...

The ISNUMERIC function is not as it appears. See this[/url] thread for details.

Does Ski Friday not require...

Partitioning can improve performance; however, 3 million rows in a table should not put you in a situation where your queries are timing out. I would not partition a...

Ditto that

Your like a mind reader Gus. That's exactly where I was headed. I was hoping to see the OPs existing DDL so we can help further. From...

I'll have to admit...

Pain.

Trace your SQL instance and find out what the SQL statement coming from the source adapter looks like.

To improve on your 15 hour process, I think we need to know a bit more about it. Can you give us an explanation of how you are 1)...