Hello, i have Oracle .DAT file created with TOAD. I noticed that it is saved with fixed width and with no column names. For example: JOHN 18 20 40 New York MARK 20 Boston Is it possible to find smart and dynamic solution to extract this data in columns? Because now SSIS see only one column in one row and i know only one solution. Download into table with one column and use substring. select substring(column,1,5), substring(column,6,10), substring(column,16,20) from temp. But problem is that there are ~100 columns and i will need extract many tables with this solution. Or maybe using Oracle there is another way to load data into file? I can't use direct connection to Oracle. Only extracted files.

You can build an SSIS package with one Dataflow task. Open the DataFlow task and drag-drop a FlatFile source component. Set the "FileName" to the file you want to load by clicking on "Browse" button and locating the data file you have. In the same window, choose "Fixed Width" from the dropdown named "Format". This will set up your source to read from the fixed-width flat file. Hope this helps. Cheers!! Muqadder.

I have tried but again he offer me only one column.. I also tried to change row width but it doesn't help..