I've done a fair amount of work importing CSV files into SQL Server 2008. I have no idea if this is still broken, but I can confirm that 2008 mishandles CSV files where the character used to surround string columns appears escaped within the column itself. Such as:
This is a perfectly valid CSV file, but SSIS will choke. I ended up writing a custom script component to load these files anyways.
That said, I absolutely love SQL Server, and I think this guy is a little over the top in his religious hatred of it. In an Enterprise setting, it works really, really well.
Comments
I've done a fair amount of work importing CSV files into SQL Server 2008. I have no idea if this is still broken, but I can confirm that 2008 mishandles CSV files where the character used to surround string columns appears escaped within the column itself. Such as:
57,4.3209,"green","He calls himself""Waldo""",98,"Y"
This is a perfectly valid CSV file, but SSIS will choke. I ended up writing a custom script component to load these files anyways.
That said, I absolutely love SQL Server, and I think this guy is a little over the top in his religious hatred of it. In an Enterprise setting, it works really, really well.