March 7, 2007 at 1:36 pm
Hi all
I have a process which copies data from SS2005 tables to MS-Access. Dont question this stupidity...I am not here to ask why !!
Any way, does any one know of a way to execute a Macro in Access from SSIS. The users want me to run the Reports for them once I finish copying the data to the Access DB.
any suggestions would be much appreciated despite the nauseating implications...
Thanks
Michael.
March 8, 2007 at 3:20 am
Michael
I feel you pain, I tried to get this to work and failed with much frustration.
What does the Macro do ? Can you duplicate the process in SQL if you already have the data there as the source for your Access.
This is what I ended up doing taking the process into an sql stored proc and outputting the data to a csv which the access database used as source for a link table.
W
March 8, 2007 at 7:35 am
you can use an ActiveX Script task to invoke an Access macro, in an .mdb or an .adp
in the ActiveX script box just type in the full path to the access file, then /x [your macro name]
March 8, 2007 at 9:47 am
Much Appreciated. I will try it out and Report....
Michael.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply