Archive for August, 2014

Fritz!Box manual firmware upgrade

August 24th, 2014

Today, I wanted to use my old 7390 Fritzbox as a repeater, because wireless reception on the second floor of my house was worthless. I tried to updte the firmware, but I couldn't get to the "update from file" tab. Finally, after much tinkering, I found that you need to adjust the view.

In old firmwares, you can get to the expert view by clicking "expert mode" at the top of the "overview" page. In more recent firmwares, you can get there by clicking the "View: Standard" link at the bottom of the overview page.

Posted in Selfish | Comments (0)

The type of the value being assigned to variable differs from the current variable type.

August 12th, 2014

This post addresses the following error message.

The type of the value being assigned to variable differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.

In my case, the error was because I tried to assign a varchar(max) to a string type variable in SSIS. It turns out that varchar(max) is not assignable to a string type object. The best option is to forcefully convert the value to a varchar(8000) or nvarchar(4000) before assigning it.

I previously stated that a string variable in SSIS can only contain 4000 characters, but that is not correct. A string in SSIS has an unlimited length, but the maximum length of an evaluated expression is 4000 characters, so concatenating over 4000 characters using an expression will result in an error. However, when assigning a value to a string from a resultset, the length is actually unlimited and you can assign over 4000 characters to a string using this method. This also means that you can work around the SSIS expression limitation by using a SQL box to concatenate two strings using a select ? + ?, for example.

Posted in SSIS | Comments (1)

SEO Powered by Platinum SEO from Techblissonline