Post reply

How to create table dynamically using source txt/csv files in sql server table.

  • April 27, 2020 at 6:39 pm

    #3746765

    I have data in text files as attachments/below. SO header row position will be change and delimiter cama(,) semicolon(;) .. etc.. I need to load in each file as separate table from header and data only.. can you please give me solution any stored procedure /SSIS package code..

     

    This is first file

    today date: 4/28/202

    ID,Name,Sal

    10,mahi,2000

    20,ravi,3000

    30,raju,1000

    Total emp: 20

    • This topic was modified 4 years, 7 months ago by  DBA.k.

    Attachments:
    You must be logged in to view attached files.

  • April 27, 2020 at 6:43 pm

    #3746766

    Please provide sample DDL, INSERT statements and desired results (based on the sample data provided) if you would like people to provide a working solution.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply