You don't need an OLE DB Destination, but an OLE...

When you installed SSAS, did you include yourself as Administrator.

SSAS Administrator <> database administrator

Try an OLE DB Destination instead of an OLE DB Source.

So you can login with windows authentication, but you can't with SQL authentication?

Nice question. Didn't know triggers had such an impact on MERGE.

No.

Do you have permissions to browse the cube?

Do you have calculations...

Read the text file using a Flat File source and pass the two columns as parameters in an OLE DB Command component.

The OLE DB Command will have a SQL command...

If it was an interview question, I sincerely hope for him he didn't pick choice 2 at the...

I've imported Excel 2010 files before without a problem.

I'll try at home tonight to make sure.

Oh yeah, join your local PASS chapter if you haven't already. Try to go to some meetings, even if the topic doesn't interest you. You might still learn something and...

+1 for Andy Leonard.

You could also start answering questions at forums. (that's what I did).

Try answering questions about topics you're not that familiar with. Do some research to find the...

Well, verify if SQL Server is allowed to have remote connections.

Check your firewall to see if it is blocking connection to SQL Server.

Enable the TCP/IP and the Named Pipes providers...

Can you elaborate a bit more on what you are trying to do?

Sample data and desired output would be appreciated.

Reading/writing of a flat file is done using a Flat File...

The first thing that I notice that is wrong is the extended properties of your connection string.

If you work with the ACE OLE DB provider, it should be Excel 12.0.

Connection...

Is there more logic behind it than just "insert data from one table from another table"?

If not, a simple INSERT INTO ... SELECT will do just fine.

INSERT (Transact-SQL)

If yes, please...