如何在SQL Server 2000中使用DTS包 [英] How to use DTS package in sql server 2000

问题描述

我正在使用Sql Server 2000，我想处理DTS包.任何人都可以帮助我解决问题..
我想导入并导出到.txt文件，我也想通过邮件发送它. :
http://www.sqlservercentral.com/articles/DTS/overviewofdtspackages/2127/ [ ^ ]

 如果，您想导入导入并导出数据然后，您可以使用 批量 插入.

例子:
http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-服务器/

MSDN:

< a href = " > http://msdn.microsoft.com/en-us/library/cc917688.aspx</a> [< a href = "  http://msdn.microsoft.com/en-us/library/cc917688.aspx" target =   _ blank" title =  新窗口"> ^</a>] 

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.

解决方案

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>]

这篇关于如何在SQL Server 2000中使用DTS包的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！