Post reply

Help with custom import of delimited file

  • July 15, 2007 at 6:14 pm

    #179709

    Hi,

    I can take the text file, bulk import it into a table (single row and single column).  I can then parse each row and each column, but I what I am trying to achieve is then take each row and map it to the respective columns in a staging table.  How can I do the mapping, and insert the data?  Any pointers towards that would be great.

     

    Thanks in advance

    KR

  • July 15, 2007 at 11:57 pm

    #719561

    Can't that be done with SSIS?

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • July 16, 2007 at 9:34 am

    #719713

    I am actually trying this in SSIS simultaneously, but I am having several problems with it:

    The ssis file is not reading the number of columns correctly, it is dropping some rows.  I did check the rows that it is dropping, and there is a row delimiter on the previous row, and yet it is not accounted for as a new row.

     

    Thanks

    Karthika

  • July 18, 2007 at 12:08 pm

    #720479

    Actually if someone who has worked with SSIS could give me a heads up on the file connection manager issue, that would be great.

    The file connection manager is not reading the number of rows in the file correctly and does not give any errors.  For example the number of rows reported by the package is 2597 while the actual number of rows in the file is 2611.  There seems to be no particular reason that I could find for the misreading.

     

    Regarding my original question,  I have been able to figure out how to do it all in t-sql but the performance with all the data type match etc.,  the performance is not so good.  So if I would like to see if SSIS performs better, but I need this problem solved first.

    Thanks

    KR

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

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