Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 798
  • Last Modified:

SSIS Oracle to Flat File

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
MSGROVE
Asked:
MSGROVE
3 Solutions
 
bull_riderCommented:
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
 
PedroCGDCommented:
give more feedback!
Regards,
Pedro
www.pedrocgd.blogspot.com
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
<< 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
 
MSGROVEAuthor Commented:
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now