It contains lots on Business Intelligence scenarios and solutions along with real problems regarding Microsoft Excel, SQL Server Reporting Services, SQL Server Integration & Analysis Services and various databases and also may contain other popular posts.

Monday, 23 September 2013

Sometime we got the data in excel sheet in number format which contain space as 1000 separator. This format could cause the problem if you use those excel data further as number in data upload process. In data upload process SSIS package will not work because of set up rules. So at that time we need to remove black space between the numbers. For that follow the below steps -Step 1 - Copy the space only after select.Step 2 - Use substitute method in excel as below screen shot -

Note : In the substitute method, space should be copied(ctrl +C).I hope this will solve the problem.Let me know here if anyone have better answer.