Problems with Data Import/Export Wizard

Hi,

I have two environements:

1) Development (Full access to SQl Server 2005)

2) Hosting SQL Server 2005, ONLY accees to the database MYDatabase, NO access to master

I would like to copy a table from my development to hosting. I would like to have an exact replica of the table in hosting. I DO NOT want to copy the whole database, just a table. I was able to do this without problems in SQL 2000/Enetrprise Manager.

I have tried to copy the table using the new import/export data wizard. I did enabled Identity Insert option. There are few problems:

1) The drop table and recreate option (under Mappings) is disabled, I can not check it. IS THIS a BUG? I have latest SP 3 aplplied

2) When I just run it I get the following errors. Also the problem is that it runs in trunsaction, I was hoping it would skip the duplicate records and just copy the ones I need. Seems it is all or nothing, very common problem in Windows based systems (same problem in Explorer when copying files)

3) I was hoping that such a simple task as mirroring a table would be easly achieved, please help

Messages

Information 0x402090df: Data Flow Task: The final commit for the data insertion has started.
(SQL Server Import and Export Wizard)

Error 0xc0202009: Data Flow Task: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint 'PK_classifieds_HotelRoomTypes'. Cannot insert duplicate key in object 'dbo.classifieds_HotelRoomTypes'.".
(SQL Server Import and Export Wizard)

Information 0x402090e0: Data Flow Task: The final commit for the data insertion has ended.
(SQL Server Import and Export Wizard)

Error 0xc0047022: Data Flow Task: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination - classifieds_HotelRoomTypes" (37) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)

Error 0xc0047021: Data Flow Task: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0202009. There may be error messages posted before this with more information on why the thread has exited.
(SQL Server Import and Export Wizard)

see if you can drop the table explicitly on the destination server and then use the import export wizard.