Integration Services

Question

Hi All, 
 I am trying to build a new process model which imports the Data from an excel file. 
 the steps i followed - 
 - Create New Process model 
 - Add the Import Excel to Database Under the Integration service/ excel tools. 
 - On the Configuration window for the Import Excel to Database what should I enter on the filed properties to get this working and once Configured how to run the process model 
 Any step by step configuration would be much appreciated 
 
 Thanks

Peter Lewis · Answer

How are you planning on using this process model? Is it a one time import or is your plan to expose a form that allows a user to provide an excel file that is imported? Depending on the answer to that question, you will need to design your process model differently: 
 
 If it's a one time import, you can upload the Excel file directly into your application using the New > Document button. Then, you can browse and find that Excel file in the Import Excel File to Database. 
 If you want to upload the Excel file from a form, you need to create an interface and connect it to your process. I'd suggest looking at the Process Modeling Tutorial for an example on how to connect a form to your process.