"Tim" <uce@ftc.gov> wrote in message
news:5a7901c3e5cb$77313060$a101280a@phx.gbl...
> --SQL SERVER 2000--
> I created a DTS Package to export to a text file and when
> i execute it on the SQL server itself it works fine. But
> if i execute it from a sql client workstation it gives me
> an error that say's "Error Opening Data File: The Device
> is Not Ready". Hmmmm having trouble finding a solution,
> any pointers would be apprecaited.
>
> Thank you
>
> Tim
> --Do not respond to email address thank you...

"Tim" <uce@ftc.gov> wrote in message
news:5a5c01c3e5e4$a0f0b6a0$a301280a@phx.gbl...
> Everything is local to the SQL server... The drive is the
> D drive on the server... it runs fine on the server it's
> just when i open it from the out side and execute it, it
> fails....
>
> Thanks
>
> Tim
>
>
> >-----Original Message-----
> >What drive are you exporting the text file to? Does that
> dive letter exist
> >on the client machine? When you execute the DTS package
> on the client
> >machine all the work is done local to that machine. Try
> using a UNC path to
> >the file if you are not already doing that.
> >
> >Rand
> >This posting is provided "as is" with no warranties and
> confers no rights.
> >
> >.
> >

"Tim" <anonymous@discussions.microsoft.com> wrote in message
news:5d7901c3e5fb$19713f30$a101280a@phx.gbl...
> The job export a single column from a table to a text
> file on the SQL server's D drive reguarless what computer
> it runs from...
>
> thanks
>
> Tim
>
> >-----Original Message-----
> >Do you have a D drive?
> >Do you have the same directory structure?
> >Is this a source or destination connection.?
> >If Source is the text file on your local D drive in the
> correct folder?
> >
> >
> >--
> >--
> >
> >Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> >www.allisonmitchell.com - Expert SQL Server Consultancy.
> >www.SQLDTS.com - The site for all your DTS needs.
> >I support PASS - the definitive, global community
> >for SQL Server professionals - http://www.sqlpass.org
> >
> >
> >"Tim" <uce@ftc.gov> wrote in message
> >news:5a5c01c3e5e4$a0f0b6a0$a301280a@phx.gbl...
> >> Everything is local to the SQL server... The drive is
> the
> >> D drive on the server... it runs fine on the server
> it's
> >> just when i open it from the out side and execute it,
> it
> >> fails....
> >>
> >> Thanks
> >>
> >> Tim
> >>
> >>
> >> >-----Original Message-----
> >> >What drive are you exporting the text file to? Does
> that
> >> dive letter exist
> >> >on the client machine? When you execute the DTS
> package
> >> on the client
> >> >machine all the work is done local to that machine.
> Try
> >> using a UNC path to
> >> >the file if you are not already doing that.
> >> >
> >> >Rand
> >> >This posting is provided "as is" with no warranties
> and
> >> confers no rights.
> >> >
> >> >.
> >> >
> >
> >
> >.
> >