Click here to Skip to main content
15,064,915 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am using Sql server 2000, i want to deal with DTS package. Can any body help me in solving my problem..
I want to import and export to .txt file, also i want to mail it.
Posted

1 solution

If you want to use DTS to do the same, check the following example:
http://www.sqlservercentral.com/articles/DTS/overviewofdtspackages/2127/[^]

SQL
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>]
   
Comments
Asif Iqbal A.Khan 17-Jun-11 3:25am
   
Thank u Prakash. Even i also got sollution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900