Hi,
You can use an ActiveX task in your DTS package and include the "RefreshAll" & "SAVE" methods for the Excel Spreadsheet. This will refresh the data in your Excel target.
For example:
Function Main()
dim xlapp, xlbooks,xlsheet,SheetName
set xlapp = createobject("Excel.Application")
set...
I like the idea of a continuosly executing job that scans a user-defined table for the next actions to be performed. It's a very useful method that I've used on several occasions. The drawback with this method is that it circumvents secuirty completely. It is the equivalent of granting "SA"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.