Solved

Fixed Length Format To SQL DB

Posted on 2012-03-23
3
261 Views
Last Modified: 2012-03-26
Hello Experts,

Is there a way to import a "fixed length format" file into a SQL DB.]
0
Comment
Question by:decoded
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 10

Expert Comment

by:plummet
ID: 37759124
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!

John
0
 

Author Comment

by:decoded
ID: 37767958
Is there way to automate this process
0
 
LVL 10

Accepted Solution

by:
plummet earned 500 total points
ID: 37768484
Yes, use SSIS to set up a job that is run on a scheduled basis
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
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.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

718 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