--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...

DTS looks for things in relation to the place where the start button is
pushed so drive mappings etc are very important.
So if on the server you hae a mapped X drive and on your PC you do not, this
would cause an error.

--
--

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 (AT) ftc (DOT) gov> wrote

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.

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

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 (AT) ftc (DOT) gov> wrote

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

OK so let me recap then

You have a package which exports to text file
That text file location is on the D drive
If the file location is defined as d:\.... then wherever you execute the
package must have that directory and drive structure.
If you are using UNC then you can place the file wherever you want so long
as you have the permissions.
When you executed it on the server was it the same account you are currently
using?

The error suggests that it cannot open the text file devide because the
location specified does not exist relative to the local computer.

--
--

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" <anonymous (AT) discussions (DOT) microsoft.com> wrote