SSIS to Integrate SQL Databases Backend and MS Access Front Ends RRS feed

  • Question

  • Just as the tittle says, has anyone ever messed around with this? Any instructional videos recommended to learn more about VBS SSIS?

    BACKSTORY: In my organization, I currently have a setup in where I run timed reports from our reporting software and automatically save those reports in excel onto a server. I then have a "refresh" form from Access that looks for the excel file name and runs multiple queries to update the records in a SQL server. Then we have multiple MS Access front end tools linked to the SQL databases for our users to performs some tasks/run reports, etc. Anyways, there are too many issues with my refresh form setup and I would like to use SSIS to get rid of them. I have a dummy demo of the refresh form, if anyone wants to have a visual.

    • Edited by InnVis Monday, September 23, 2019 9:48 PM Added Context
    Monday, September 23, 2019 6:56 PM