Remote DTS

Tech-Archive recommends: Fix windows errors by optimizing your registry

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
.

Relevant Pages

  • RE: Remote DTS
    ... > I have a SQL server which I use to store Itemised phone bills. ... > Can anyone suggest a way of running a DTS package from a local machine which ...
    (microsoft.public.sqlserver.dts)
  • RE: Remote DTS
    ... > Try using the full UNC path back to the users CD drive ... >> I have a SQL server which I use to store Itemised phone bills. ... >> Can anyone suggest a way of running a DTS package from a local machine which ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS.. Flatfile Read..... otrher alternative.... ?
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > Currently I am loading a table by reading a flat file. ... I am using DTS package to read the data. ... > file and to load the data into the table in SQL. ...
    (microsoft.public.sqlserver.dts)
  • Re: Flat file parsing into SQL Server 2000
    ... parsing a flat file into SQL Server 2000 using C#. ... I do something similar with a DTS package. ... I did not tried BCP though, so you should also explore that path. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: How to capture SQL statement messages in DTS log file
    ... I have several SQL Server 2000s and a couple of SQL Server 2005 servers ... Then instead of PRINT in your DTS package, ... The execution of the following DTS Package succeeded: ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.dts)