Post reply

Import data from text file (with inconsistent data) into a sql server table

  • January 29, 2010 at 1:14 pm

    #137795

    Is it possible to import part of a text file in sql server table ? Say there are 10000 rows in the text file . The first 200 have inconsistent data. I want to import data from 201 row onwards . How do I achieve this in DTS / SSIS / or sql code.

    Thanks

  • January 29, 2010 at 1:53 pm

    #1110985

    If you know exactly how many rows you want to skip, then try kicking up the "header rows to skip" to 200 in your flat file connection manager.

    If it is variable, you can import the data into a single row without delimiters, and then figure out which rows you want to delete later.

    John

  • February 4, 2010 at 4:56 pm

    #1114083

    How do I import the text file into 2 different tables using SSIS .

    The consistent data into 1 table and the other inconsistent data rows into a different table .

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

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