November 2010 – Knowledgebase

Solving the SSIS 2005 Excel Connection Manager error 0x80040E09

26 November, 2010 Roel van Lisdonk 2 Comments 1 category

I was getting a 0x80040E09 error, when exporting some rows to an Excel file in SSIS 2005. This was caused by the destination Excel file being read-only. After I cleared the read-only checkbox on the

Solving the SSIS 2005 Excel Connection Manager (Excel Destination) Error 0x80040E21

26 November, 2010 Roel van Lisdonk 0 Comments 1 category

I was getting as 0x80040E21 error on a SSIS 2005 package when exporting some rows to an Excel file. In my case this was caused by an input column of the type varchar(max) after

Convert datetime to string in format HH:mm:ss in T-SQL

26 November, 2010 Roel van Lisdonk 0 Comments 1 category

CONVERT(VARCHAR(8),GETDATE(),108) Result 14:12:30 Other examples print convert(varchar(30),getdate(),121) — Result: 2011-05-09 12:04:31.883 print convert(varchar(30),getdate(),113) — Result: 29 Apr 2011 13:41:23:327

Convert datetime to string in format dd-MM-yyyy in T-SQL

26 November, 2010 Roel van Lisdonk 0 Comments 1 category

convert(varchar(10),getdate(),105) Result 26-11-2010

Adding date and time to a log file path in SSIS 2005

26 November, 2010 Roel van Lisdonk 0 Comments 1 category

Right click your log file connection, click on properties In the property windows click on Expressions > ConnectionString Expression Add the expression: (DT_WSTR,1000) ( "C:\Temp\" + RIGHT("0" + (DT_STR,4,1252) DATEPART("year",GETDATE()),4) +

‘Sys’ is undefined or ASP.NET Ajax client-side framework failed to load in a ASP .NET 4.0 website

18 November, 2010 Roel van Lisdonk 12 Comments 1 category

I was getting the the error [‘Sys’ is undefined] and [ASP.NET Ajax client-side framework failed to load] in an ASP .NET 4.0 website. After reading and following the post [http://weblogs.asp.net/chrisri/archive/2007/02/02/demystifying-sys-is-undefined.aspx] I found my solution. De

Month: November 2010

Solving the SSIS 2005 Excel Connection Manager error 0x80040E09

Solving the SSIS 2005 Excel Connection Manager (Excel Destination) Error 0x80040E21

Convert datetime to string in format HH:mm:ss in T-SQL

Convert datetime to string in format dd-MM-yyyy in T-SQL

Adding date and time to a log file path in SSIS 2005

‘Sys’ is undefined or ASP.NET Ajax client-side framework failed to load in a ASP .NET 4.0 website

Using XBMC on mine ASROCK 330 Pro

Using an T-SQL update statement with a @COUTNER variable to provide consecutive numbers in a column

How to import a Microsoft Word 2010 document in OneNote 2010

Adding a reference to an OData service in a C# .NET 4.0 class library