Are you sure all values of the V_Version column can be converted to integers?

At first glance, you didn't miss anything.

Enable logging and try to find out if there are any configuration messages.

If you run the package in BIDS, do you have any warnings/erros...

What exactly do you mean with "ssis map"?

Do you have a SharePoint server installed?

Nice question. It was tempting to select FOR, AFTER, INSTEAD OF :-D.

Add more RAM to your machine?

Or design your dataflow a bit better so that it doesn't consume so much memory.

What are you trying to do?

Is there any business rule that says which salaries should be subtracted by other salaries?

Or is it just random?

Since you are trying to compare rows with each other (which is...

Great question! Certainly didn't know that.

Thanks for the overview.

Fantastic question, thanks!

For .xlsx you need to use the ACE OLE DB provider. Normally this is automatically selected when you choose Excel 2007 in the Excel Connection Manager.

Also make sure you are...

I forgot:

if the result of the query is huge, you'd be better off with importing each table seperately and then join in SQL Server itself. Using the dataflow will result...

Your solution should work, but make sure to put an ORDER BY on the join columns and mark the input as sorted in the advanced editors of the sources, as...

Since it is some sort of XML specification for Excel, maybe try a XML Source?

Please do not crosspost.

It wastes people's time and fragments replies.

Original post with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1197301-391-1.aspx