• Koen Verbeeck (2/11/2014)


    What exactly is wrong with the Excel Destination in SSIS?

    Because of your question, I decided to figure out the Excel destination and write an article on how to use it.

    Now I have a question for you; have you ever tried to use the Excel destination?

    It is, for all practical purposes, unusable, and even if you do manage to get it to work, it doesn't give you any more functionality than writing a CSV file.

    So, have you ever used the Excel destination? And if you have, how is it better than simply writing a CSV file?