Export to CVS file

Todd C

2010-03-23 12:40:01 UTC

Definately permissions.

You used the Import and Export wizard to create your job on the fly? Try
going through the wizard again but this time have it save it as a new SSIS
package. Poke around the package so you fully understand what is going on.
--
Todd C
MCTS SQL Server 2005

Post by Brian
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)
.