Loading x number of CSV files into x number of unique tables of a database

  • hope everyone had a wonderful break!

    Just thought of revisiting this and check if the files I uploaded were sufficient enough

  • hmm.. for some reason it says that the last post by me but I can't see it

    UPDATE: weird.. I could see only 3 pages and once I posted this message, the 4th page of the thread showed up

    • This reply was modified 2 years, 10 months ago by  masterelaichi.
    • This reply was modified 2 years, 10 months ago by  masterelaichi.
    • This reply was modified 2 years, 10 months ago by  masterelaichi.
  • masterelaichi wrote:

    hmm.. for some reason it says that the last post by me but I can't see it

    UPDATE: weird.. I could see only 3 pages and once I posted this message, the 4th page of the thread showed up

    Strange things are afoot in the forum at the moment!

    1) I am no longer receiving e-mail notifications when there is activity on posts I am subscribed to.

    2) The toolbar which allows you to do formatting and enter code blocks seems to have vanished.

    3) The default font in which replies (like this) are typed appears to have changed.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • Phil Parkin wrote:

    masterelaichi wrote:

    hmm.. for some reason it says that the last post by me but I can't see it

    UPDATE: weird.. I could see only 3 pages and once I posted this message, the 4th page of the thread showed up

    Strange things are afoot in the forum at the moment!

    1) I am no longer receiving e-mail notifications when there is activity on posts I am subscribed to.

    2) The toolbar which allows you to do formatting and enter code blocks seems to have vanished.

    3) The default font in which replies (like this) are typed appears to have changed.

    yeah, I noticed that as well. I was getting email notification straight into my inbox but it now goes to my junk mail

  • Phil Parkin wrote:

    masterelaichi wrote:

    hmm.. for some reason it says that the last post by me but I can't see it

    UPDATE: weird.. I could see only 3 pages and once I posted this message, the 4th page of the thread showed up

    Strange things are afoot in the forum at the moment!

    1) I am no longer receiving e-mail notifications when there is activity on posts I am subscribed to.

    2) The toolbar which allows you to do formatting and enter code blocks seems to have vanished.

    3) The default font in which replies (like this) are typed appears to have changed.

    Ok... I thought that was just me. I reported all the symptom to the webmaster earlier today and haven't heard back yet. I can't paste even plain text never mind code. Another symptom is that the LIKE link at the top of each post is gone unless I hit f5. Only the LIKE link is fixed by that.

    If you don't want to list all the symptoms, send an email to webmaster@sqlservercentral.com and simply report that you're having exactly the same issues as Jeff Moden. I've also verified that other sites like SQLTeam is not having any such problems so it's specific to this site.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • hi, just wanted to revisit this post. I have been sent another 100 odd files and have uploaded them manually which is really tiresome. Hope someone can suggest a better way to do this

     

    Thanks!

    • This reply was modified 2 years, 9 months ago by  masterelaichi.
  • Ah, there you are.  The forum had a probem with email notifications that they just fixed in the last 2 days and I couldn't find this thread.  I'll go back and revisit what we've talked about so far.

     

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Ah, thanks Jeff!

     

Viewing 8 posts - 46 through 52 (of 52 total)

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