DTS - Beginner

[mani]

Can anyone tell me where I can learn more about DTS.
As I have to export data from a .CSV(comma separated file) into SQL Server.

[Kevin Mendonsa]

Just try it it is very simple. Make sure you use the DTS wizard and select Import of data and select the last option text from the drop down list and then select comma as the delimiter and that is all you need. If you need additional help let me know.
Thanks,
Kevin


------------
mani at 10/9/00 3:37:56 PM


Can anyone tell me where I can learn more about DTS.
As I have to export data from a .CSV(comma separated file) into SQL Server.

I want to read about the DTS service can you tell where I can find the material.

[Kevin Mendonsa]

I do not which books you have access to but there is a book only on DTS SQL 7.0 extremely comprehensive called DTS from Wrox press/publishers (try amazon.com). But also most admin books give you some info on the topic but not in as much detail as the one I mentioned above.
Thanks,
Kevin


------------
at 10/9/00 3:44:06 PM


I want to read about the DTS service can you tell where I can find the material.

[Kevin Mendonsa]

------------
mani at 10/9/00 3:37:56 PM


Can anyone tell me where I can learn more about DTS.
As I have to export data from a .CSV(comma separated file) into SQL Server.

[Kevin Mendonsa]

Try this link for some information on DTS
http://www.inquiry.com/techtips/thesqlpro/browse.asp?pro=thesqlpro&catID=643
Thanks,
kevin

------------
mani at 10/9/00 3:37:56 PM


Can anyone tell me where I can learn more about DTS.
As I have to export data from a .CSV(comma separated file) into SQL Server.