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

Posted on 2007-08-08
Medium Priority
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
  • 2
LVL 11

Accepted Solution

Swindle earned 375 total points
ID: 19658451
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

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

Author Comment

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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

615 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