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!
LVL 9
Tone' ShelbyMicrosoft® Power BI, Power Apps & O365 Design, DevelopmentAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.