DTS Error

[bigmelon]

I am moving information from one server to a new one. I have like 15 DTS statements that I use and 9 work fine and 6 of them give me an error. The error I'm getting is "There is already an object named 'Whatever' in the database. The First thing that my DTS's do is rename the table to WhateverBU and that step completes without error. Then when I try to to Create Whatever I get that error.

Any Ideas??

Thanks,
Jeremy

 

[maswien]

I guess the DTS statement maybe executed in batch, you may need two jobs, the first rename the table, the seconf moving data.

 

[maswien]

bigmelon,

Can you also post the DTS code you wrote? Thanks

 

[bigmelon]

I'm not sure what you want me to post...im looking at the layout but what code is there??

 

[maswien]

You mentioned renaming table, how did you do that without coding?

 

[bigmelon]

do u want the code from each individual step? i use the dts on the old server and it works fine so thats why it doesnt make any sense

 

[bigmelon]

My first step is to rename the table:

SP_RENAME '[BLOOD]', 'BloodBU'

This executes fine. Then the second step is to create the blood table and it fails

 

[bigmelon]

CREATE TABLE [[BLOOD] (
[Surg_Proc_Number] nvarchar (10) NULL,
[Cell_Saver_Machine] nvarchar (1) NULL,
[Cell_Saver_Returned] float NULL,
[Homologous_RBC] float NULL,
[Platelet_Pheresis] float NULL,
[Platelet_Concentrate] float NULL,
[Cryoprecipitate] float NULL,
[FFP] float NULL
)

 

[bigmelon]

Any Ideas??

 

[maswien]

You need make sure the rename did work, it might not succeed for some reason (for example, you run the DTS many times and forget to drop table BloodBU ) and then when you create table Blood, SQL Server give you that error.