February 24, 2004 at 9:57 am
Is it possible to open an excel file for viewing within a DTS package?
February 24, 2004 at 10:12 am
If all you want to do is open the Excel file for READ-ONLY view why use a DTS package???
Sure it can be done by writing an ActiveX script inside the DTS package but I think that would be major overkill. Why not send an e-mail containing the link for the EXCEL file instead??
Good Hunting!
AJ Ahrens
webmaster@kritter.net
February 24, 2004 at 10:17 am
My package does some data manipulation step prior to adding data to the warehouse.
After the manipulation a QA step is performed and the results are sent to Excel.
I was hoping I could view the results then decide to finish loading the data into the warehouse.
February 25, 2004 at 3:25 am
What about sending the results to another XL file that has has code in that will continue the loading at the click of a button.
February 27, 2004 at 5:47 pm
Use Execute Process Task in DTS.
Win32 Process: C:\Program Files\Microsoft Office\Office10\EXCEL.EXE
Parameters: c:\File.xls
This will open the file and allow you to view or manipulate data. The DTS package will not continue until you close Excel. As soon as you do close Excel, it does continue to the next step. To stop it you could the add the following activex task:
m=msgbox ("Continue?", vbyesno)
if m=vbno then Main = DTSTaskExecResult_Failure else _
Main = DTSTaskExecResult_Success
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply