import data from columns containing carriage return line feeds into sql table nvarchar column?
first, I haven't used SSIS for years (it was called something different Data Transformation Service maybe?) I just used the import wizard to get bulk rows into a SQL table. However, some of the source columns contain data with carriage return line feeds. I would like to import those fields into a SQL column. The import wizard only transferred the date up to the first carriage return line feed. Is there a 'fairly' easy step by step explanation of how to accomplish this, if it can be done at all? Thank you!
October 14th, 2011 5:34pm
is your file TEXT QUALIFIED? i mean does your fields surrounded by characters?like this: "one","two","three" all qualified with double quote. if yes, just set the qualifier character in the flat file connection manager's Text Qualifier , and then everything will be OKhttp://www.rad.pasfu.com
October 14th, 2011 5:43pm
Here is a direct paste from my copy of one of the Excel cells. So no, it doesn't appear these are comma delimited. "Signal/Telecom Port ( > 3m) DC Input Ports AC Input Ports"
October 14th, 2011 6:18pm
Here is a direct paste from my copy of one of the Excel cells. So no, it doesn't appear these are comma delimited. "Signal/Telecom Port ( > 3m) DC Input Ports AC Input Ports" is the source Excel file? so why you don't use EXCEL Source? it will fetch data as you wanthttp://www.rad.pasfu.com
October 14th, 2011 6:40pm
If you mean Extract FROM Excel file as Source and SQL Server table as Destination, that is what I am currently doing.
October 14th, 2011 7:13pm
also in the excel connection string add the IMEX=1 as below: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\..\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1"http://www.rad.pasfu.com
October 14th, 2011 8:39pm