DTS

I used DTS to export data to a text file.
Then I used these text files to import to another database, during the DTS
import, why I did not need to specify the table to be imported the data ?Hi Alan
This would be a two stage process, export the table data and then the second
process would be to import the data from the text files. You would need two
tasks (or jobs) to do this, and it sounds like you have only specified the
export part! You may want to transfer the data directly from one table to the
other in your DTS job, which will be quicker. If you definately need the data
to be put to file you may want to try using the BCP utility instead (See
books online for more about this).
John
"Alan T" wrote:
> I used DTS to export data to a text file.
> Then I used these text files to import to another database, during the DTS
> import, why I did not need to specify the table to be imported the data ?
>
>