Insert individual records into SQL2000 table from a tab and line return character string in a SQL record

Posted on 2007-08-08
Last Modified: 2013-12-05
I am trying to split a tab delimited record in a sql2000 table into individual records. The record holds about 2000 rows of tab delimited records, with line return characters at the end of each row. I would like to insert the records into individual records of a second table. There are 8 columns of data, and the rows vary between a few hundred and a few thousand at a time.

I have managed to parse it by row, but it is very slow. I will need to do this several times (7 or 8) every 5 minutes.
Any ideas? Thanks
Any ideas?
Question by:smee_bruce
    LVL 11

    Accepted Solution

    Could you give us a sample of the code you are using to accomplish it now?  Without having a lot of details about the exact situation, it sounds to me like you could accomplish this using DTS (Data Transformation Services) really easily.  You could even create a DTS package, save it, and just execute it when needed or set it up on a schedule.

    Author Comment

    Will have to be in the morning, will get back to you then..thanks

    Author Comment

    my DBA found a solution, which will do for the moment. Sorry I didn't get back

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now