HI,

I need transfer data from a dbIII to a accounting program (Peachtree).
I use SQL server 2000 as a tool.
I created a new database in sql.
Import the couple tables into sql database from DBIII. (no problem)
Questions the colum I try to export cvs file were not within the sql database.
G/L account, Account for Sale Tax, Apply to invoice, stmt note .... Can I
create a table and put in the default data, but how can I add those deafult
information to the export csv file.
Customer ID in SQL use numbers (DBIII prgram auto generated), Customer ID in
Peachtree use each first letter of the company name. Customer address and
phone number the were both same. Can I create a refernce table in sql server
with Peachtree customer ID, address and tel number? but how can I add those
deafult information to the export csv file.

Can I do it all within the dts, or I need create SP after dts?

Thanks,

Dannie