none
Alternatives to SSIS to copy data to an excel file

    Question

  • Hello there,

    Can anyone tell me if there are any other alternatives to using SSIS packages to copy the data into an excel file?

    Any free tools, links etc would alos be fine. Thanks for your help.

    Sree

    Friday, September 13, 2013 2:08 PM

Answers

  • Hello Sree,

    How would you like the functionality implemented?

    From where are you copying the data?

    These above define a lot.

    In short, you can issue an OPENROWSET command to populate Excel from a database (E.g. SQL Server), you can write your own MS Office project in Visual Studio that operates on the Office APIs to do some more complex processing. Lastly, you can even use a VBScript, or PowerShell.

    Tools? Why not Google that out? Are you willing to pay for them?


    Arthur My Blog

    Friday, September 13, 2013 3:03 PM