I am currently working on multiple Access and Excel documents that have multiple Push Buttons, that all do different things. I am wondering if there is a way to automate these buttons so they run just as if they have been clicked, when the package is run. I am sure I could change the vb, but considering there are ALOT of push buttons in Access Forms and Excel, I was looking for a quick way to run these instead of manually opening the every file and clicking the button. Any suggestions are welcome Thanks!

Also some forms need certain inputs such as a file directory before the push button is used, others require date sets to be input the the button is pushed to create the new reports.

Hi, You can use script task to open the file and then click those buttons and once finally file will be ready you can load by using Data flow task. Are those buttons available on same sheet from where you need to read the data or these buttons create data on other sheet. If you have buttons, filters on same sheet it is going to be difficult to read data by using built in drivers, So you might want to consider read the file and create csv or insert directly into staging table by using scripting. If these buttons create clean sheet that has no buttons, filter etc then you can go with Data flow task with built in drivers. Thank you http://sqlage.blogspot.com/

All of them are on different sheets. I am not very expirienced in vb scripts, and I have forms that require certain inputs (See Picture), actually almost all of the forms require some sort of manual entry before it can run. Is there a quick and easy way to fill in this data within the script or SSIS?

Hi, I would seriously consider trying to use SSIS tasks and components, etc., perhaps in combination with code in Script Task(s) to perform the logic that the Access forms, etc., do themselves, rather than automating Access and/or Excel from an SSIS package. Office products were not built for server-side automation, for several reasons discussed, as discussed in: Considerations for server-side Automation of Office http://support.microsoft.com/kb/257757 Here are a couple of other threads discussing the topic: http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/3ce8f022-840e-469e-8d4b-980a2e83aa54 http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/823f69b2-0841-4a1b-8803-e306af7b0586 Thanks, Cathy Miller

Hi, I would seriously consider trying to use SSIS tasks and components, etc., perhaps in combination with code in Script Task(s) to perform the logic that the Access forms, etc., do themselves, rather than automating Access and/or Excel from an SSIS package. Office products were not built for server-side automation, for several reasons discussed, as discussed in: Considerations for server-side Automation of Office http://support.microsoft.com/kb/257757 Here are a couple of other threads discussing the topic: http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/3ce8f022-840e-469e-8d4b-980a2e83aa54 http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/823f69b2-0841-4a1b-8803-e306af7b0586 Thanks, Cathy Miller