Loading Data from text files

  • How should I Load Data into SQL Server 2000 Database from text files, using DTS Packages.

  • First, put a sql server connection object in your package and set the parameters to the db that you are loading the data into. Second, add a text source connection object and set that to the text file you are importing. Third, add a workflow connection between the two connection objects and map the fields in the text file to the fields in the table you are importing the data into. The field mapping is much like the import data wizard in Access so if you are familiar with that, you should be able to navigate through the process fairly well...

    hth,

    Michael

    Michael Weiss


    Michael Weiss

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply