SQL Server Script

  • Posted:
  • Proposals: 1
  • Remote
  • #36355
  • Expired
Oleg K. has already sent a proposal.
  • 0

Description

Experience Level: Intermediate
We have 50 CSV files containing from 3,000 to 50,000 records each with approximately 45 fields per record - all fields and layouts are consistent. total of around 500,000 records.

We need a SQL server script that will work through each of the files in a specified folder, open each, read each and then write the contents of each to a single \'flat\' table with the exact record field layout.

attached csv is sample data and record field layout.

from time to time the data in the csv files is updated so we need to be able to handle this as a batch job without manually modifying the csv files.

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.