Hey guys, i have found a nice bug in Reporting Services. If you have configured a DataSource and add a field from another DataSet to the Data Source and try to preview your Report in Visual Studio you get an exception that the report cannot generate. Then Visual Studio make a restart. The Error in the...
If you import Data from a specified Source periodically in an Integration Service Project and you need to update existing data in the SQL Destination the best workaround for this is as following: First define a Source in the data flow e.g. Ole DB Source, make sure that your Columns does not contain NULL...
If you receive the following error message There is already an open DataReader associated with this Command which must be closed first and you are sure that all dataReader are closed the following workaround can help you. The MARS default settings has changed at release RC1, so multiple Result Sets are...
Hi, I'm just getting confused today, because I tried to import Data from a Excel Source, but one column contains only NULL Values, but in the Excel Source there are a few entries for this column. So the problem was SSIS Excel Source only look at the first 8 Rows if they contain the same value SSIS...
I run today in many problems. I have installed the Service Pack 1 for SQL Server 2005. The first problem was the Service Pack was not installed correct in Event Log I received the following error: Installation Failure: Windows failed to install the following update with error 0x80070643: Microsoft SQL...