DTS File Reference Runnig from VB

[Dimm]

I have a DTS package that imports data from an Excel Spreadsheet, the file is located on the SQL Server and has a path D:\file\filename.xls

The DTS works fine when run on the server.

I am now trying to execute the DTS from vb. The DTS runs ok, but I get an error

Additional information: 'D:\file\filename.xls' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

Question: How do I correctly reference teh file in my DTS so it can be executed from a workstation.

TIA

 

[johnwm]

Instead of:

'D:\file\filename.xls'

use a local sharename eg.

'\\myserver1\file\filename.xls'

where the D: drive on the server is shared as myserver

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[Dimm]

Johnwm,

Excellent thanks for that, I was trying similar but got my path incorrect Fileserver\\file\filename.xls

\\Fileserver\file\filename.xls works a treat

Thank you