• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 269
  • Last Modified:

Fixed Length Format To SQL DB

Hello Experts,

Is there a way to import a "fixed length format" file into a SQL DB.]
  • 2
1 Solution
You can import a fixed width ASCII file into SQL Server using the import facility - I use SQL 2008 R2 so I'm not sure about older versions, but I believe it is available.

RIght click on a database, select "tasks" and then "Import data..." which should start the import data wizard, then "Flat file source" and follow the instructions

Hope that helps!

decodedAuthor Commented:
Is there way to automate this process
Yes, use SSIS to set up a job that is run on a scheduled basis
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now