 | |
DTS "Error opening datafile"
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
DTS "Error opening datafile" -
11-17-2003
, 07:52 PM
#2
| |||
| |||
|
|
I have a DTS package which creates a connection to a SQL Server database table. It then writes the contents of the a table in the database to an ASCII text file in a folder on the same machine using a Transform Data task. My NT domain account is the owner of the package and my account has write access to the folder and file. When I run the package I get the following error: "Error opening datafile: The device is not ready." Does anyone know what might be causing this problem? Thanks. |
#3
| |||
| |||
|
|
-----Original Message----- Is this even when you run the package manually ? -- ---------------------------- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Robert" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:03dd01c3ad76$947975c0$a501280a (AT) phx (DOT) gbl... I have a DTS package which creates a connection to a SQL Server database table. It then writes the contents of the a table in the database to an ASCII text file in a folder on the same machine using a Transform Data task. My NT domain account is the owner of the package and my account has write access to the folder and file. When I run the package I get the following error: "Error opening datafile: The device is not ready." Does anyone know what might be causing this problem? Thanks. . |
#4
| |||
| |||
|
|
This is my first experience with DTS. How would I run the package manually? Thanks for taking time to help me with this. -----Original Message----- Is this even when you run the package manually ? -- ---------------------------- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Robert" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:03dd01c3ad76$947975c0$a501280a (AT) phx (DOT) gbl... I have a DTS package which creates a connection to a SQL Server database table. It then writes the contents of the a table in the database to an ASCII text file in a folder on the same machine using a Transform Data task. My NT domain account is the owner of the package and my account has write access to the folder and file. When I run the package I get the following error: "Error opening datafile: The device is not ready." Does anyone know what might be causing this problem? Thanks. . |
#5
| |||
| |||
|
|
This is my first experience with DTS. How would I run the package manually? Thanks for taking time to help me with this. -----Original Message----- Is this even when you run the package manually ? -- ---------------------------- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Robert" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:03dd01c3ad76$947975c0$a501280a (AT) phx (DOT) gbl... I have a DTS package which creates a connection to a SQL Server database table. It then writes the contents of the a table in the database to an ASCII text file in a folder on the same machine using a Transform Data task. My NT domain account is the owner of the package and my account has write access to the folder and file. When I run the package I get the following error: "Error opening datafile: The device is not ready." Does anyone know what might be causing this problem? Thanks. . |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.