Hi, we have a manually process that works something like this. A word document created .docx with some data and also it saved as .pdf file. Then there is another excel file that gets to be saved as a .pdf too. At last these two .pdf files get merged into one .pdf file and placed on the web. 1- Can I use ssis to read the .docx file. I know if I save the .docx to .zip and view the zip file you will find the word document xml. 2. I wonder if that possible then I could use the ssis to import the data from excel into sql and write a report using ssrs. Appreciated any help/input. thanks.

1- Using SSIS to import .docx is possible if you done the following a. Select Flat file as a DataSource in SSIS wizard b. You must format data into the .docx file to be in either simmi coulmns, tabs, ...etc i mean in format could be inserted as columns into certian SQL tabl 2- Using SSIS to import excel it is possible by selecting the excel as a data provider, the point the wizard to the physical path of the excel file, and this could be done be creating a new project using visual studio of type Service Integration

1- Using SSIS to import .docx is possible if you done the following a. Select Flat file as a DataSource in SSIS wizard b. You must format data into the .docx file to be in either simmi coulmns, tabs, ...etc i mean in format could be inserted as columns into certian SQL tabl 2- Using SSIS to import excel it is possible by selecting the excel as a data provider, the point the wizard to the physical path of the excel file, and this could be done be creating a new project using visual studio of type Service Integration

you can use Excel source for importing excel data into any destination you want. also you can use script component as source, and write your own .net Code to read data from word document , and load data to any destination you need. this is a sample of script component as source: http://www.rad.pasfu.com/index.php?/archives/38-Script-Component-as-Source-SSIS.html let me know if you need more details.http://www.rad.pasfu.com

1- Can I use ssis to read the .docx file. I know if I save the .docx to .zip and view the zip file you will find the word document xml. If the other options don't work you could always unzip the file and use an XML source (hopefully the word document doesn't contain to much layout stuff).Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

thank you to all for their input. SSISJoost, do you have an example or a site you can refer me to for more detail of how can I go about your way? thanks

thank you to all for their input. SSISJoost, do you have an example or a site you can refer me to for more detail of how can I go about your way? thanks Haven't tried it myself, but you can unzip the docx document with for example a Script Task and in the Word folder of that zip file you will find the xml files which you can read with the standard XML Source adapter in SSIS. Let us know your findings.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

thank you to all for their input. SSISJoost, do you have an example or a site you can refer me to for more detail of how can I go about your way? thanks Haven't tried it myself, but you can unzip the docx document with for example a Script Task and in the Word folder of that zip file you will find the xml files which you can read with the standard XML Source adapter in SSIS. First try reading the xml without unzipping. If that works, add the unzipping part... Let us know your findings. Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com