November 4, 2002 at 9:24 am
I have created a DTS package and I'm getting mixed results.
step 1 I create an Excel workbook via a View. This works perfectly
step 2 I run the Excel workbook through a VB6 standard exe to create charts. These will be saved as HTML files. The VB6 exe works flawlessly if I run it from my desktop. When I place it under DTS it "pretends" to work but does nothing, i.e., I don't get an error code but my files are not creating either.
Any thoughts on what I might do here?
Your assistance and your site are greatly appreciated.
November 5, 2002 at 5:16 am
Never done this so not much help. However when I have had problems with transferring apps to server where they don't work but do on my workstation. The only advice I can think of is to try the obvious.
1. Does the app know where the workbook is, is it expecting it in the same dir or is it referenced in some way.
2. Does the server/user have access to the workbook (my common favourite).
3. Are all the app's dependancies installed on the server (my second favourite)
Hope this helps.
Far away is close at hand in the images of elsewhere.
Anon.
November 5, 2002 at 11:54 am
Well I'm finally getting an informative message or sorts. It says 1004: Cannot open file xxxxx.xls so I would guess this falls under your 2nd explanation. The thing is, if the first step of the DTS job can write the file then why can't the second step open the blasted thing?
November 6, 2002 at 3:28 am
Is the error display from your app?
Error 1004 can be caused by trying to open xls with older version of Excel than the one used to create it!
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply