If you want to use DTS to do the same, check the following example:
http://www.sqlservercentral.com/articles/DTS/overviewofdtspackages/2127/[
^]
If you want to import and export the data then you can use bulk insert.
Example:
http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/
MSDN:
<a href="http://msdn.microsoft.com/en-us/library/cc917688.aspx">http://msdn.microsoft.com/en-us/library/cc917688.aspx</a>[<a href="http://msdn.microsoft.com/en-us/library/cc917688.aspx" target="_blank" title="New Window">^</a>]