DTS

What are you talking about?
I started a transfer with the DTS wizard then I
>realized that I had the name spelled wrong in the to part
Whats the to part?

>Cannot create file 'C:\MSSQL7\DATA\dbGrade.mdf' because
>it alredy exists.
Then dont try to re-create it.

>When I check the test server this file does exist.
>What do I need to do to get my transfer to go?
>Can I just delete the above mentioned file?
>What is the purpose of the data folder?
Of course you can. But keep in mind this is a db file. It
sounds though as you just created it so it's probably
empty. Drop the db from Enterprise Manager.
Why are you exporting to a file anyways?

>--Original Message--
>I am transfering data from a production server to a test
>sever. I started a transfer with the DTS wizard then I
>realized that I had the name spelled wrong in the to part
>so I removed that db from the drop down list. Now when I
>try to do another transfer I get the following error
>message.
>Cannot create file 'C:\MSSQL7\DATA\dbGrade.mdf' because
>it alredy exists.
>When I check the test server this file does exist.
>What do I need to do to get my transfer to go?
>Can I just delete the above mentioned file?
>What is the purpose of the data folder?
>.
>
The to part that I was refering to is on the Chose Destination page of the DTS wizard in the database drop down list. In that list it has a new option. After selecting that I typed in the name of the database that I want to create with the data transfer
. I am not trying to create the file that gives me the error I assume that this is something that is created by the DTS.

DTS

What are you talking about?
I started a transfer with the DTS wizard then I
>realized that I had the name spelled wrong in the to part
Whats the to part?

>Cannot create file 'C:\MSSQL7\DATA\dbGrade.mdf' because
>it alredy exists.
Then dont try to re-create it.

>When I check the test server this file does exist.
>What do I need to do to get my transfer to go?
>Can I just delete the above mentioned file?
>What is the purpose of the data folder?
Of course you can. But keep in mind this is a db file. It
sounds though as you just created it so it's probably
empty. Drop the db from Enterprise Manager.
Why are you exporting to a file anyways?

>--Original Message--
>I am transfering data from a production server to a test
>sever. I started a transfer with the DTS wizard then I
>realized that I had the name spelled wrong in the to part
>so I removed that db from the drop down list. Now when I
>try to do another transfer I get the following error
>message.
>Cannot create file 'C:\MSSQL7\DATA\dbGrade.mdf' because
>it alredy exists.
>When I check the test server this file does exist.
>What do I need to do to get my transfer to go?
>Can I just delete the above mentioned file?
>What is the purpose of the data folder?
>.
>The to part that I was refering to is on the Chose Destination page of the D
TS wizard in the database drop down list. In that list it has a new option.
After selecting that I typed in the name of the database that I want to cr
eate with the data transfer
. I am not trying to create the file that gives me the error I assume that
this is something that is created by the DTS.