I'm trying to import different length CSV files into one table. I'm using a script given in this example get me almost there... http://consultingblogs.emc.com/jamiethomson/archive/2006/07/14/4226.aspx I say almost because now I'm having issues with qualified text. I need items surrounded by double quotes to go into one cell, but this script I'm using seems to be ignoring the options for qualified text and delimiters that I set up in my flat file connection manager. "Adams, Sam" is still being split up into two cells when it should go into one. I'm sure there's something I can modify in the function to handle this, but I have no idea where to begin. I'm fairly new to this stuff and I know squat about scripting. Anyone have any ideas? I hope this makes sense. Thanks, Josh

Hey Joshua, How about changing any instances of "," (your delimiters) to something like "|". This will preserve any intended commas in the data. JS

If there's a way to incorporate this into my current script or package, then I guess that would work. I just have no idea how to go about coding it. I'm working with large files and I'm trying to make it so we don't need any additional processing done on them. Would just like to throw them through this package and call it a day.

Use three double quotes instead of single double quotes for "Text Qualifier" in "Flat File Connection Manger Editor". This will make SSIS interpret comma separated double quotes qualified text as a single column. It worked out in SSIS 2008 R2. Try out.

You might try one of the other flat file source components that are available and a bit more robust than that offered out of the box. For instance, bob bojanic of the SSIS team wrote the delimited file source available on codeplex for free. Please mark answered posts. Thanks for your time.