• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 267
  • 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.]
0
decoded
Asked:
decoded
  • 2
1 Solution
 
plummetCommented:
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
 
decodedAuthor Commented:
Is there way to automate this process
0
 
plummetCommented:
Yes, use SSIS to set up a job that is run on a scheduled basis
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

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