Post reply

xml to pdf using sql server

  • June 16, 2015 at 8:08 am

    #309279

    Hi,

    Convert 100 xml files individually to pdf's and zip them in a folder along with the source files.

    Can it be possible in SQL server BI world?

    If possible make this an automated process for every 100 files.

    Thanks In advance for your help.

  • June 16, 2015 at 12:11 pm

    #1805825

    gosven07 (6/16/2015)

    Hi,

    Convert 100 xml files individually to pdf's and zip them in a folder along with the source files.

    Can it be possible in SQL server BI world?

    If possible make this an automated process for every 100 files.

    Thanks In advance for your help.

    That functionality isn't built into the SQL Server database engine.

    You can use xp_cmdshell to execute external DOS command line calls, but this requires disabling some default security settings.

    http://www.sqlservercentral.com/Forums/Topic1181509-145-1.aspx

    The best way to do this would probably be an SSIS package. For XML -> PDF conversion, you would probably need a 3rd party component.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • June 16, 2015 at 12:16 pm

    #1805827

    yeah i'd go programming language on this, whether SSIS, Powershell C# ,VB.Net, or whatever you are

    comfortable with.

    As Eric said zip functions and conversions are not native to SQL, so you might as well do it all in a platform that supports all of it, including querying data from SQL.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 16, 2015 at 1:54 pm

    #1805881

    Thank you for your replies .

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

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy