How to create a MS Word document using SSIS package?

Using Script Task, I have written a code to create a folder and create a MS Word document inside the newly created folder. It is working on the local machine but it is not working on the server where the package is deployed to. The folder is created successfully, but the Word document file is not created. For Word document creation, I had to refer another DLL where I had included an additional namespac开发者_运维问答e Microsoft.Office.Interop.Word. Is there anything else to do before deployment ?

Based upon rfonn's comments, your choices are as follows:

1. Install Word 2007 on the server.
2. Re-do your package on a dev box with Word 2003 installed and deploy to your server.
3. Use some other tool to generate the Word Document.

SSIS is generally used for movement of data, so while it is possible to do what you are doing, it is likely not the best tool for the job. If you are capable of writing code in a script task to do what you want in SSIS, it is possible to write a program (VB or C# or any other tool you choose) to do the same thing without SSIS being wrapped around it. My money is on option #3 being your best choice.

I guess you missed installing the Office PIA.

After installing the relevent PIA according to your Office version, add a reference to microsoft.office.interop.word (.NET) file in your project (ssis script in VS).