Duplicate post, continue here: http://www.sqlservercentral.com/Forums/Topic1777814-2799-1.aspx

Why don't you handle this in SSIS before you load the data? An expression on your pipeline column would fix this. The real question is, why do you...

I said difficult, not impossible. This is as far as we're going to get w/o some more info from you on your process.

Agreed. Your original question asked for a simple way to convert you...

If it's not a finite list, trying to run the load in parallel is going to be very difficult. Since you have to dynamically set the destination connection via...

Where are the dynamic database names coming from? A table? Is it a finite list of destinations or will they need to be changed, added to?

Running the package...

So then the Destination database is changing? What part of the connection string is changing?

For the record, you would not install SQL Server on the Access machine. You'd run the package from the same SQL Server that you are trying to move the...

I didn't read all the way through this, but it's on a reliable site. A google search provides several examples....

https://www.mssqltips.com/sqlservertip/2656/simple-step-by-step-process-to-import-ms-access-data-into-sql-server-using-ssis/

You can easily sync your Access table w/ a SQL Server table via SSIS.

How are you determining the Destination servers? Are they a set group of servers, or will the destinations be changing?

I do lookups/merge joins against 1MM+ datasets all day long. With a SCD2, you're not going to be looking up against the whole table anyways. Your are always...

We have similar issues from time to time in our dev environment. If rebuilding statistics/indexes does not help, it may be a major difference in the data that is...

Jeff Moden (4/8/2016)

---

John Rowan (4/7/2016)

---

With this problem in mind, I'd recommend creating views for your end users. You can re-model this solution on the back end in the database, but...

Glad to help. I'd definitely get your sales hat on. It's hard when analysts and business folks try to dictate data structures and how we store and serve...