PHISSUG

    Hi to all, can somebody help me with this problem? I tried the DTS of SQL but it does not work. I tried creating a data flow in SSIS but it seems that my CSV file is too big because the I/O buffer overflowed. What to do?????

How bout Bulk insert?

http://www.sqlteam.com/article/using-bulk-insert-to-load-a-text-file

~hope this will help

There could be other reasons that resulted to the buffer overflow exception and not just the size of your csv file. Is this just a firehost insert, or you have transformations in the process? As there are other ways of doing this, lets try to solve it first with SSIS as this is the best candidate for the job.

I don't know what's a firehost is. What I did was create a data flow (Source: flat file = my csv 6GB file) and (Destination: SQL Server database table). That's it. But when I tried running it, the item for the source generates an error about the overflow. I will try using the BULK Insert tool from the Control Flow tools. Thanks. :)

i think that overflow is caused by BAD data in your csv.

i created a 6G csv file and import it to table using SSIS and it works fine. I used Flat File Source and Ole DB destination and No transformation, just direct import.