Solved

SSIS Oracle to Flat File

Posted on 2009-05-10
4
767 Views
Last Modified: 2013-12-19
I am trying to configure a package to take an oracle query and export it as a flat file

I have OLE DB Source and my query runs correctly. I can see the Preview Data
Next I added a Flat File Destination and map the columns.

When I run it I get the errors below:
Flat File Destination [77]. Cannot write to the data file
This is not enough space on the disk
Cannot copy or convert flat file data for column Course_name

0
Comment
Question by:MSGROVE
4 Comments
 
LVL 6

Accepted Solution

by:
bull_rider earned 200 total points
ID: 24351355
You can try changing the location for the buffer files by setting the BLOBTempStoragePath and BufferTempStoragePath properties of your data flow task. Let me know if that helps. And if not, if you could try posting the screenshot of the error message or paste the exact error message I would be able to help you.
0
 
LVL 22

Assisted Solution

by:PedroCGD
PedroCGD earned 100 total points
ID: 24352384
give more feedback!
Regards,
Pedro
www.pedrocgd.blogspot.com
0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 200 total points
ID: 24352766
<< Cannot write to the data file
This is not enough space on the disk >>

Change the destination file path to some other location where you have write access and with sufficient free space.
0
 

Author Closing Comment

by:MSGROVE
ID: 31580009
I needed to change the column type in my external files to match the field types in the data base. Once I made the changes it ran. Thank you for pointing me in the correct direction.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Some sers suddenly getting error popup msg 28 89
SQL Help 27 45
SQL Insert parts by customer 12 33
SQL SELECT query help 7 37
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question