I have a SQL server which I use to store Itemised phone bills. The bills come
on a flat file on a CD which I then use a DTS package to bulk insert into a
table..

I now want to give this task to a user to do, but I have no 'front end', and
I don;t want to teach someone how to use DTS..

Can anyone suggest a way of running a DTS package from a local machine which
imports a file which is on a CD in the lacal machine's CD drive, ideally from
a shortcut?

What I have tried is to use the DTSLOAD.EXE and pass a global variable like
"E:\BILLFILE.CSV" to the DTS package to be used as the data source, but I
always get 'Cannot find specified file' presumably because the server is
looking for the file in it's own "E:" drive...

Thanks

Nick

Try using the full UNC path back to the users CD drive

"NH" wrote:

Sorry, I forgot to mention that I had already tried that with no luck...

"PaulaPompey" wrote:

Sorry, scratch that - it DOES work. It was my code which didn't support UNC
paths..

Thanks for making me re-check my code...

Nick

"NH" wrote: