The IsNumeric function has a very variable interpretation algorithm. In order to get only numeric values following statement should be…
October 28th, 2009
SSRS: Add Excel Export Link to Report
No Comments, SQL Server, by Ralf.How to add a Excel Export Link to a Report Add an item (e.g. TextBox, Image, etc.) and open the…
September 30th, 2009
SSIS: Execute Package via Stored Procedure
1 Comment, IT, SQL Server, by Ralf.There are two options executing SSIS packages: – xp_cmdshell command (not recommended for security reasons) – sp_start_job command The main…
August 26th, 2009
SQL Server: Security Check List
No Comments, SQL Server, by Ralf.In the following you find a compact catalog of steps which should be considered in a SQL Server environment. It…
July 22nd, 2009
Linked SQL Server: Encrypted Connection
4 Comments, SQL Server, by Ralf.Linked SQL Server (applies to SQL Server 2005 / SQL Server 2008 / later) It can happen that an application…
July 7th, 2009
SSIS: SQL Server Agent Job (run packages)
No Comments, SQL Server, by Ralf.If you experience following error “Executed as user: MyDomain\SQLServer. The package execution failed. The step failed.” then check that your…
July 3rd, 2009
SSIS: Import localized Date columns under different regional settings
No Comments, SQL Server, Uncategorized, by Ralf.Importing Date values e.g. from Flat Files it can happen that the format of the date is different to the…
April 17th, 2009
SSIS: Split Excel cell values into rows
6 Comments, .Net, SQL Server, Uncategorized, by Ralf.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…