Does the server that you running SQL Server from have access to the correct filepath,

Can you browse to it from the server?

if you click on file --> save copy of packagename.dtsx

this will bring up another menu, in here select sql server as your package location.

and i thought it meant Royal Auto Club, as in they come and fix your car for you incase of a breakdown..

Save the ssis package to SQL Sever, cick save as..

In sql server create a new job and add a step of run ssis package, select the package you...

I have found from experience that Merge performs better than doing the steps individually,

from BOL

By using the MERGE statement, you can replace the individual DML statements with a single statement....

you can use any dev environment that can access a database, I would use visual studio. But if this is too expensive you could look at using one...

You may struggle to write up a standard document that covers what will happen in BI project in detail, as each project is different. You could outline the basics...

Can you be a bit more specifc, is there any particular issue that you are having with the MS Bi suite?

You will need to move the logins across as well as these won't be part of the restore.

Once you have moved the logins yuo can map them to the users...

normally the '\' deliniates the server name and the instance name so i can't see how you could have a '\' in an instance name,. and if you...

One of the main differences i found was that Informatica gave the ability to send individual columns form each task to seperate tasks and as long as they joined up...

Yes the amount of advice that is given to Shrink a transaction log is bit worrying, do t-log backups and manage the size of the log correctly. ...

You will still need to have a unique key for your dimension, if you have only selected to use the year and month attributes then the cube will have...

You can mirror the publisher, you just need to esure that you are using a remote-distributor and that your agent is made fail-over aware

also you need to ensure that...

Either Sort

or

Slowly Changing Dimension task.

both are horrible..