strange error on ssis package excution

I was totally blank when i got the error saying OLE DB provider 'STREAM' for linked server '(null)' returned invalid data for column '[!BulkInsert].sak_beregnetrente

I was doing a bulk data transfer from faircom ctree server to sql server 2005 using ssis. the faircom db is a large database and very difficult to figure out where the error was.
I then tried to check the null values of the data column "sak_beregnetrente". but it contained more than 20 million records. then i used a ssis derived column to check the null using the expression

[sak_beregnetrente] == NULL(DT_R8) ? 0 : [sak_beregnetrente]

this will check the NAN values for the column data because the data type is float.

eahhhhh, this solved my problem

can not open chm file

Hi all I faced the problem which does not show the contant of the chm files. i search though the web and found the following content. I took it from http://www.nik.com.au/archives/2005/04/06/chm-help-files-error-the-page-cannot-be-displayed/#comment-307582

CHM problem

I just had a very weird problem in Windows XP with CHM help files (Compiled HTML). A CHM file is the Microsoft preferred format for help files within applications, and in my case I had many books in CHM format and I was surprised that after some housekeeping that none of the CHM files in a certain directory would open, and they would give a “The page cannot be displayed�? error while showing the contents in the left-hand pane.

After some fiddling around and searching online to no avail (Microsoft identified the problem but offered no solution) I found out that the reason for the problem was because there was a hash (#) in my file path. The files that were not working were in a folder called ‘c#’ and the hash in the directory name was causing problems. The problem arises when there is a hash in any part of the directory path to the CHM file. The problems seems to arise because the hash character signifies an anchor in HTML so the CHM file is getting a bit confused as to where to look for the content.
Share This