Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Export to CSV and email RE: Export to CSV and email

  • September 23, 2014 at 8:21 pm

    #1747702

    Frank Cazabon (9/18/2014)

    Jeff Moden (9/17/2014)

    If you don't mind using SSIS, here's one way... just "skip the zip"...

    http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64028/

    Thanks Jeff,

    maybe I should have mentioned the client only has SQL Express 2012. I have a feeling that SSIS is not available in the Express versions, is that right?

    That's correct. SQL Express 2012 is the data engine only and then with some limitations. If you want to do this from there, you'll either need to do it from the DOS prompt or bring xp_CmdShell into play.

    As a bit of a sidebar, I've always been a bit angry that MS never put better file handling features into T-SQL and says to "Use SSIS instead".

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