iLearn

Writing this post only for internet explorer as not aware of the settings of other browsers such as chrome/mozilla. To be honest I have to dwell down and read so many websites before I was finally able to solve it on my own. Here are steps: 1. Open the internet explorer with 'run as admin' option. 2. Click on internet options on top right corner, click on security tab, click on local intranet tab, click on sites, select the automatically detect intranet network option 3. Go back to security tab, click on custom level, scroll down to last option User Authentication and select automatic logon with current username and password. After applying above settings restart the internet explorer and open your report browser by typing - http://localserver/reports. Hope this helps. Thanks

PROBLEM - ERROR EXECUTING SSIS PACKAGE FROM SQL JOB. Error Message would be something like this - failed to load xml file... SOLUTION - Make sure that your integration services and sql agent services are running under same account, you can check it by typing services.msc at run window and checking for logon options of these 2 services

Hi Guys, Anyone interested in online training for MSBI (SSAS, SSRS and SSIS), please contact @ er.lokeshsharma08@gmail.com. Features - Best material (practical and theoretical) for becoming familiar with this latest exciting technology.

Recently I encountered a problem of handling dates while converting a vb6 code to .net code. Problem - cant predict what the output of (date1 - date2 ) would yield in vb6 Solution - vb6 stores dates as doubles so if we use an arithmetic operator such as '-' and '+', the result would be in double which then will be converted to date. so in order to replicate something like this in .net please try the following code: Dim i As Date, k As Double, j As Date   i = "01/01/2000"   k = 23 / 12 - CDbl(i.ToOADate())    j = CDate(Date.FromOADate(k)) It is better if we use all the date functions such as datediff, dateadd while dealing with dates in vb.net however if we want to replicate the above behavior we can definitely use above code snippet.