August 28, 2002 at 10:34 am
I'm new to SQL Server. I set up a database and a table. I want to import a text file into the table. I start the import/export wizard and choose data source: Microsoft text-treiber(txt.csv). Under "select or create a datasource name for the ODBC driver". No matter what I do here, I can't get the file imported. I don't even understand the options. And the 'help' isn't very helpful. It doesn't explain what the options mean and what to do for any given desired outcome.
If someone can help, or point me to some resource that can walk me through the basics using some sort of tutorial, that would be great.
Thanks in advance,
Angela Pearman
August 28, 2002 at 10:37 am
There are some beginner articles on DTS. I'd start there. Create a text file conneciton, select your file and use the "properties" to verify this works.
Then add a SLQ connection and a data transfer task.
http://www.sqlservercentral.com/columnists/bknight/dtsbasics.asp
Steve Jones
August 28, 2002 at 11:09 am
After the beginner articles if you want to continue to expand your DTS skills, you may want to then look at the DTS book Brian Knight is a co-author on: Professional SQL Server 2000 DTS. It's published by Wrox.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
August 29, 2002 at 3:13 am
You might like to try this url http://www.sqldts.com. An excllent site devoted solely to DTS. Last time I looked there was an article giving a step by step guide on importing a text file.
I have found it is possible to please all of the people all of the time if you do exactly what they want. Harold Macmillan 1961
I have found it is possible to please all of the people all of the time if you do exactly what they want. Harold Macmillan 1961
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply