it really depends on what mail system you are using, for exchange 2010 you can use the webservice to get the mail message and then store this in your...

seems like a bit of dodgy advice from your 3rd party experts. The one file per CPU advice was given a while ago but has since been disproven to...

use a lookup transfomation to check if the columns match and then use the match and no-match data flow connections to handle the matched and non-match data

have a look at the data compare tool from Redgate, this will be able to easily generate the change scripts for you... though it does cost but in my opinion...

it sounds like you would be better off simply storing the xml files in a column in one table, sure it would not perform well but it would be...

do you need a new excel workbook created each time you run the package?

or do you need the existing workbook updated?

it really depends on your data source and how the data is structured. but in theory it is possible by using ssis, though i will say that it...

I am not sure there is any way to do it automatically, but you could always create a perspective that only includes the dimensions that are mostly used...

I would guess that it runs on server 2, as this is where the agent job is that is running package.

you could always run Resource Monitor on both servers to...

I find it strange that the difference is that great, I can usally get data flows to match the performance of insert/select give or take a few MS..

Perhaps change...

you can use fast load on the destination,

make sure you use a select statement in the source rather than connect directly to the table/view.

make sure you are doing no uneccesary...

have you checked the server can be reached from the other server?

are the mirroring end-points enabled?

I think the confusion lies in assuming that a bit data type = a boolean data type which is not the case, as SQL server does not handle boolean data...

when you restore with no recovery then the database will be in a 'restoring' state, until you bring in online. so what you are seeing is correct.

This is required for...

create one package with a data flow that has Two data sources (your two procedures) an two destinations (your two files)

or you could have two seperate data flows if the...