Link to home
Start Free TrialLog in
Avatar of MSGROVE
MSGROVE

asked on

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

ASKER CERTIFIED SOLUTION
Avatar of bull_rider
bull_rider
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of MSGROVE
MSGROVE

ASKER

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.