Loading space delimited data from flat file to SQL Server database.

Posted on 2006-05-17
Medium Priority
Last Modified: 2008-02-01
I have to download data file (with records of not relational, not normalized data) from FTP server and load the data into SQL Server database. What are different ways of accomplishing the task? Tools available: SQL Server 2000 and Visual Studio .Net 2003 . Thank you.
Question by:quasar_ee

Accepted Solution

bwdowhan earned 1000 total points
ID: 16704866
Hi quasar ee,

You can SQL DTS to create a process that can be scheduled to accomplish this task. One way to do this is to go to Enterprise Manager and right-click on the database you want to import the data into. Select [All Tasks] --> [Import Data] and follow the wizard to select your datasource (TEXTFILE), destination, etc... At the end you can choose to save the task as a DTS Package.

Once you have the data in SQL Server, you can create a stored procedure to take the data and move it into the appropriate tables in your database.

LVL 75

Expert Comment

by:Anthony Perkins
ID: 16705400
Friendly reminder: The following questions are well past abandoned, please attend to them:

1 03/22/2006 250 Generating select, insert, update, delet...  Open Microsoft SQL Server
2 04/03/2006 125 Can I somehow generate insert statements...  Open Microsoft SQL Server

LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 200 total points
ID: 16705442
Also you can use  BCP / Bulk insert  for the same purpose..

Author Comment

ID: 16710575

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

840 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