Brian
2010-03-22 12:05:56 UTC
Hi,
I am having a problem doing a quick and dirty export from a table to a csv
file. It is not a job just a quick run, never experienced this before, but
I just upgraded to SQL Server 2008 from 2000. I have applied file
permissions to the file but it still won't let me write to the file. Below
is a log of the export. Any help is appreciated.
Brian
Operation stopped...
- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Success)
- Setting Destination Connection (Success)
- Validating (Success)
- Prepare for Execute (Success)
- Pre-execute (Error)
Messages
. Information 0x402090dc: Data Flow Task 1: The processing of file "Z:\
users.csv" has started.
(SQL Server Import and Export Wizard)
. Warning 0x80070005: Data Flow Task 1: Access is denied.
(SQL Server Import and Export Wizard)
. Error 0xc020200e: Data Flow Task 1: Cannot open the datafile
"Z:\users.csv".
(SQL Server Import and Export Wizard)
. Error 0xc004701a: Data Flow Task 1: component "Destination - users_csv"
(22) failed the pre-execute phase and returned error code 0xC020200E.
(SQL Server Import and Export Wizard)
- Executing (Success)
- Copying to E:\Microsoft SQL
Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\vtc-users.csv (Stopped)
- Post-execute (Stopped)
Messages
. Information 0x402090dd: Data Flow Task 1: The processing of file "Z:\
users.csv" has ended.
(SQL Server Import and Export Wizard)
. Information 0x4004300b: Data Flow Task 1: "component "Destination -
users_csv" (22)" wrote 0 rows.
(SQL Server Import and Export Wizard)
I am having a problem doing a quick and dirty export from a table to a csv
file. It is not a job just a quick run, never experienced this before, but
I just upgraded to SQL Server 2008 from 2000. I have applied file
permissions to the file but it still won't let me write to the file. Below
is a log of the export. Any help is appreciated.
Brian
Operation stopped...
- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Success)
- Setting Destination Connection (Success)
- Validating (Success)
- Prepare for Execute (Success)
- Pre-execute (Error)
Messages
. Information 0x402090dc: Data Flow Task 1: The processing of file "Z:\
users.csv" has started.
(SQL Server Import and Export Wizard)
. Warning 0x80070005: Data Flow Task 1: Access is denied.
(SQL Server Import and Export Wizard)
. Error 0xc020200e: Data Flow Task 1: Cannot open the datafile
"Z:\users.csv".
(SQL Server Import and Export Wizard)
. Error 0xc004701a: Data Flow Task 1: component "Destination - users_csv"
(22) failed the pre-execute phase and returned error code 0xC020200E.
(SQL Server Import and Export Wizard)
- Executing (Success)
- Copying to E:\Microsoft SQL
Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\vtc-users.csv (Stopped)
- Post-execute (Stopped)
Messages
. Information 0x402090dd: Data Flow Task 1: The processing of file "Z:\
users.csv" has ended.
(SQL Server Import and Export Wizard)
. Information 0x4004300b: Data Flow Task 1: "component "Destination -
users_csv" (22)" wrote 0 rows.
(SQL Server Import and Export Wizard)