Moving Data between local server and main server

Go to Microsoft Sql server > Import and Export data. Go through the DTS wizard by selecting source and destination and click on next. Now select the option
Copy table(s) and view(s) from source database and then select which and all tables are required by selecting it and mapping it and click transform link.

1. select the option delete ... of data so that while moving data old datas get truncated and new data got moved.

2. Select the option append... in order to append the data.

and save the DTS package if required schedule the package.

If You select copy objects and datas...option, then getting error like 'You must use sql server 2005 management express' or 'some user' does not have valid permission.