How to create a MS Word document using SSIS package? -

Using the script function, I have written a code to create a folder and inside a newly created folder a MS Create Word documents. It is working on the local machine but it is not working on the server where the package has been deployed. The folder has been created successfully, but the Word document file is not created. For word document creation, I had to mention another DLL where I had included an additional namespace Microsoft.Office.Interop.Word . What is something to do before deployment? Based on RFON's comments, your choice is as follows:

Install Word 2007 on the server.

Redeem your package on a Dev box with Word 2003 and Justin on your server.

Use some other tools to create Word documents.

SSIS is usually used for the movement of data, so while doing what you are doing, it is possible, probably not the best tool for the job. If you want to do in SSIS, then you are able to write written code in writing, it is possible to write a program (select VB or C # or any other device) to do the same thing without the SSIS wrapped around it is. My money is on option # 3, which is your best choice.