nullreferenceexception was unhandled in ASP.Net or C#

Hi Folks,
I got the below error

nullreferenceexception was unhandled

And I browsed so much for the solution....finally i understood that all I had to do was check the connectionstring name

i,e i had
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["CCDBRegistrationString"].ConnectionString);

while the correct connection string name was

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["CCDBConnectionString"].ConnectionString);

Cannot insert the value NULL into column 'id'? ASP.Net

Hi Folks,
If you get the below error while being a fresher in ASP.net ...

Cannot insert the value NULL into column 'id'?

Then please add identity property to your primary key

[ID] [int] Not NULL IDENTITY(1,1),

check the below link for more clarification

http://stackoverflow.com/questions/10013313/why-is-sql-server-throwing-this-error-cannot-insert-the-value-null-into-column

Add 2 labels to a bar chart or stacked chart in SSRS or add a label at the middle in the Bar chart

Hi Folks!

As soon as I came to office, I got a call from my collegue to make some changes to the allready existing report. 1 such change was to add a data label at the center of the bar chart. I performed the below steps to make it work. Enjoy charting !!!


https://www.youtube.com/watch?v=c7qDBWVAymE&feature=youtu.be

https://www.youtube.com/watch?v=c7qDBWVAymE&feature=youtu.be

Connect to SAP source and Destination from SSIS

To connect to SAP Source and destination you will first need to download Microsoft SQL server 2008 Service Pack 2 Feature Pack from the below link

http://www.microsoft.com/en-in/download/details.aspx?id=6375

Click on Download and try to download SAP related file only (to avoid time consumption). Later run this file. After installing, open SSIS project in BIDS. Click on Tools> Choose Toolbar options and then under SSIS data flow objects you will find SAP BI destination and SAP BI Source. You can now proceed to connect to. You will also fine the SAP BI connection manager in the Connection manager window in SSIS. 

SSIS error - has lineage ID 8828 that was not previously used in the Data Flow task - - -VS_NEEDSNEWMETADATA

SSIS error -  has lineage ID 8828 that was not previously used in the Data Flow task - - -VS_NEEDSNEWMETADATA


To resolve the above error

This happens when there is a change in the SQL server Schema design and your meta data in SSIS package becomes outdated or recently any changes has been applied. You can open the Data Source in your Data Flow Task and save it without any manual changes. Editor will report the issue if there is any and you can update the source appropriately and consequently the transformation as well.

Or
If the code is outdated and the dataflow task source or any task content is changed then this error occurs. To resolve this, double click on each of the task that has this error. You should get an option of "Do you fix the metadata....issues automatically..." Click on Yes. Your error should go away.

If your error is still not fixed then recreate each of the tasks and execute it to make the code work. 

The external columns for component "OLE_SRC Get are out of synchronization with the data source columns.

The external columns for component "OLE_SRC Get Transactions" (187) are out of synchronization with the data source columns. The external column "TotalSalesUnits" needs to be updated.
The external column "TotalSalesValue" needs to be updated.


To resolve the above error Set the ValidateExternalMetadata property for the task to False

[OLE DB Destination [761]] Warning: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.

[OLE DB Destination [761]] Warning: Cannot retrieve the column code page info from the OLE DB provider.  If the component supports the "DefaultCodePage" property, the code page from that property will be used.  Change the value of the property if the current string code page values are incorrect.  If the component does not support the property, the code page from the component's locale ID will be used.



To resolve this error perform the below steps

1. Double click on the Data flow task

2. Right Click on the OLE DB SOurce data flow task.  

3. Then go to the properties tab and set the AlwaysUseDefaultCodePage peoprty to True.