Does your client have a clean backup?

SQL DBA experience will help to some extent,

If you are planning on working with datawarehouses then I would try and get an understanding of Dimensional modelling and Kimball Methodology.

You...

Do you really need the disk space that badly ? , it is good practice to leave a bit of room for growth..

You should look at getting a MSBI certification, however you will need a lot more than passing exams to become a BI architect. You would need to have...

This wont make a difference if...

Also you can consider becoming a specialist in several db sytems. eg.

MS SQL DBA + MySQL DBA

as this is in demand

Also, you can only use SQL destination when you are running your package on the same server as your destination.

It is a whole lot quicker than the OLEDB destination

You should be able to do all of those alerts using SQL server agent alerts.

also for number (IV) are you sure you want an alert on blocking and...

Why did you think it was best to avoid temp tables and use table variables instead?

Without seeing the data, most people trying to help will just be stabbing the dark, haing the data and the table structure means people are able to setup a...

Have a look at the actual execution plan, this will show you where the performance bottlenecks are. Post them here if you need help analysing them.

Also you should...

Its really hard to say without seeing the data, do you have an example of data that was returned by one query and not the other.?

You need to do transaction log backups to keep the transaction log maintainable

have a look at this article for some advice

http://www.sqlservercentral.com/articles/64582/

Also the size of the t-log should not...

The edition of SQL server shouldn't make a difference when using LIKE.

Can you post the code that you are using? and are you sure both tables have the same...

That error message is fairly clear, you will need to have integration services installed to run maintanence plans as they are SSIS packages..