How many records this table contains? Definately clusted index will effect the inserts. If there are not many records you can drop the indexs,insert the data and recreate...

Not sure of what is the requirement. Can u please elborate more with an example?

Delete the old file and create again every time u run the dts. I am sure that u can do in DTS

check the following link

http://bytes.com/topic/sql-server/answers/78672-dts-package-owner

You can use linked server. Read BOL for further information

Use union

Fetch data means, select only. There is no DML operations involved

Duplicate Post

You can cancell. But depending on batch size of insert the rol lback take time.

insert into table with(rowlock) values()

More inputs needed.

Check the performance monitor or profiler. Basing on the result you can decide

Check fragmentaion on the table. It should improve the speed after attaining good fragmention.

Use the following and check

IF isnull(@eventype,'') !='rmo'

Your are using rollback transactions without commit statement.

You need to use begin tran,commit and rollback in the block.