Oh okay. Thanks for the clarification. I guess I should learn a little MDX eventually... just so much to cover and so little time! (and not enough brain cells to...

Oh, so from a user's perspective, it's effectively the same... thanks!

Why not use a For Each file loop and then use an Excel connector and insert that way?

You probably need some serious normalization of the data you're importing. 255 columns...

Okay, let me approach this from a different angle, and maybe I can think this out.

The sale would always be associated with a given customer and the salesperson at the...

You could use something like this.. I would recommend commenting out the EXEC statement and just printing the SQL to make sure the SQL statement is correct.

USE [mydatabase]; ...

You're not specifying a way of telling which records are already in the destination table. Without that, you're going to insert the same records over and over.maybe you could use...

For Each [file] Loop?

How are you going through the table?

You could use a TOP VALUES query...

SELECT TOP 5 *

FROM dbo.MyTable

WHERE ...

Where are you sending the records? I guess you could use OFFSET....

Okay, thanks... That's a great design! Not sure who thought of that, but just wow.

Here's a screenshot. Note the lack of individual tables in the field list on the right.

Every other time, the tables are broken out and then the columns are under...

If it's clinical trials data, that's all covered under HIPPA/PHI rules.

Having Access involved is a security disaster waiting to happen. It has no built-in security anymore. If at all possible,...

You can lead a horse to water....

Isn't that kind of presumptuous? Send me your paycheck, and then I'll do your job.

If you are only trying to compare email1, then this will return all email addresses being used by more than one employee...

SELECT email1

FROM #temp1

GROUP BY email1

HAVING COUNT(*)>1;

If you need to...

So what did you try?

I don't have an Oracle instance to connect to, but when you run the wizard to add a Data Source, you can choose "Oracle Database" from...

A quick search turned up a ton of information...

Oracle Connection Type (SSRS)

Data Sources supported by SSRS

How to add an Oracle data source in SSRS