• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 326
  • Last Modified:

Fileshare Directory Of InfoPath Forms submitted to a SQL Server 2008 database table with SSIS

Hi All:

I have been presented with a requirement of developing a nighly process solution to take a fileshare directory of multiple infpath forms using ssis to extract the data entered into each form and populate a record for each form in a SQL 2008 datbase table and then having another instance of an infopath form created with the ability to access any given record in the populated database table so that the record can be updated via the new instance of the infopath form if needed.

Is this possible and if so, any link how to's, guidance and/or example project references, sites & references is much appreciated!
0
Tone' Shelby
Asked:
Tone' Shelby
1 Solution
 
Clay FoxDirector of Business IntegrationCommented:
Just make a database form.  It can then insert, query, and update data in your tables directory and is much simpler than what you are describing.

www.qdabra.com has a tool kit for doing it all via webservices too.

Lots of other benefits having your data in SQL too.
0
 
Tone' ShelbyMicrosoft® Power BI, Power Apps & O365 Design, DevelopmentAuthor Commented:
Thanks very much for the response and I agree with third party software or SharePoint itself from a forms library would be the answer but at this point buying software to do it isn't going to be an option for me with this client.
 It was mentioned that I will have to use SSIS, to take the multple infopath forms from a  directory fileshare, extract the xml data from them and populate the sql 2008 database warehouse in a nightly process & then have another form then extract from the SQL table again for updating if necessary.
I am looking for ideas on making this happen with these "interesting" stipulations.
 
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now