Phil Parkin (3/6/2013) Debbie Edwards (3/6/2013)
Im horribly close to having to sign this off as a no can do at the moment which is really dissapointing.
From what I can gather I possibly need to execute the VBA Script using c# script within the IS Task but again there seeems to be no documentation on how to do this.
But Again I cant get enough out of the information I have to know that that is right
You need a Script Task in SSIS which will perform the Excel automation for you. This task would need to effectively load the spreadsheet in Excel - programmatically - and call the macro. That's roughly what the link I posted was doing - albeit from a native C# app rather than a script task (should not be much difference).
Without C# or VB skills, I believe you will struggle to complete this task, I am afraid.
What I was hoping for is something like
This is the extra bit of code you need to add and this is why...
And here is where you put the VB Code you have already created.
At the moment I dont know what section is what, or if I need to change the code I have already created to include more information.
I thought there would be something somewhere that would take you through the process step by step so I could learn how to do it.
Do I need to add C# code or can I stick with VB?
From what you have just said I do have a script task in SSIS
The Macro I have successfully does everything I need it too with the xls
The only bit I have missing is where I call the macro within the task
Thats the only bit Im missing.
And I cant work out where that bit is in the link you sent me an how it works with the VB Script I already have.I do hate so being beaten when I feel like Im so near.