PDA

View Full Version : Excel VBA user form



nadiya
07-23-2014, 01:37 PM
Hi,
I have a user form in excel VBA has a combo box with ssis package names in it. When i click on the button then it should execute the package for the combo box list selected. I have created names in the combo box but not aware how to execute ssis packagewhen button is clicked.
i have the code created to execute the ssis package but want to know how to write the code for the button click to link with my code
Please help

Bob Phillips
07-23-2014, 02:31 PM
See http://sqlage.blogspot.co.uk/2013/07/ssis-how-to-run-ssis-package-by-using.html

nadiya
07-23-2014, 04:44 PM
Thanks xld, I am aware of executing the ssis package from excel vba. I think i was not clear before. I am unable to link the button click with the combo box list. I have multiple ssis packages names in the combo box. when selected a ssis package and click on execute the package should execute. I do not know how to link button and combo box.

Bob Phillips
07-24-2014, 01:10 AM
Where is the combobox, on a form or a worksheet? If the latter, is it a forms combo or ActiveX? Any chance of uploading the file?