Post reply

SSIS Help!

  • January 5, 2019 at 1:48 pm

    #2018075

    Heh... doesn't matter.  Real Excel file or Excel converted to CSV... you'll have the same problems because the problem isn't in the file type.  Unless the Excel file is laid out like a table in SQL Server (and they're usually not because it's too ugly a format that's not like having things in month columns, etc), then you're still going to have to put up with unpivoting, etc, etc, etc.

    That's a part of the reason why I don't use SSIS for such things. I use the ACE drivers which allows me to do everything I need to in T-SQL, which handles all of that quite nicely.

    As a bit of a sidebar, I'm never surprised but frequently amazed at the fact that Microsoft doesn't make products that easily allow the exchange of data with other Microsoft products except, possibly, by using another of my least favorite things in the world and that's XML.

    --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)

Viewing post 16 (of 15 total)

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