Here I would like to show you a solution for following problem. One source row coming from Excel contains several…
April 17th, 2009
T-SQL: Split column in several rows
No Comments, .Net, SQL Server, by Ralf.problem If I have a column with several values (separated by CR) which I need separated into rows then following…
April 16th, 2009
SSIS: Excel Import Column Data Types
2 Comments, .Net, OpenSource, PHP, SQL Server, by Ralf.When Excel data is not coming into SSIS right, then do the following: use option “IMEX=1” in ConnectionString (Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\..\MyExcel.xls;Extended…