Post reply

Any Alternatives to installing MS Office on SQL server 2008 server

  • April 18, 2011 at 3:45 pm

    #249554

    I have a SQL server 2008 server. I have a user whose SSIS package (which runs on the server via a agent job) outputs a MS excel document and then Manipulates the content via VBA to create its final report file. This file is mailed via the SSIS package.

    Beacuse of the ability to make changes via VBA, the Output file format cannot be csv (as the data/report manipulation cannot be done). The only option I see to install MS Office on the SQL server. This I think is a security risk. Are there any add-ins that can do the job of MS excel. Can you guys suggest any other alternatives here. Thanks

  • April 18, 2011 at 4:00 pm

    #1313122

    You can manipulate VBA programming with dotnet and create the DLL and use this dll as a CLR in SQL Server

    Regards,

    Syed Jahanzaib Bin Hassan

    MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

  • April 18, 2011 at 4:03 pm

    #1313123

    That will be little outside of the "how to " knowledge of the LOB who write/manage these SSIS packages. Thanks for the suggestion though

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

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