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

How do you create a stored procedure to import fix position file

How do you create a stored procedure to import a fix position txt file into Microsoft SQL Server?  

I have following fix position data in the  text file

Postition                   Fieldname                           Sample data
1 - 5                           ID                                         12345
6 - 10                         sample1                               ABCD
11 - 12                       sample2                               ZZ
13 - 19                       startdate                              061214

thanks
nick
0
countyprob
Asked:
countyprob
2 Solutions
 
ste5anSenior DeveloperCommented:
Take a look at BULK INSERT.
0
 
nemws1Commented:
Usually one would do this with an SSIS package and not with a stored procedure.
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

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