Your browser is executing scripts on this page . If message persists , please make sure that you are visiting a correct site and Javascript support is enabled in your browser and then try again

Hi Folks,

Your browser is executing scripts on this page . If message persists , please make sure that you are visiting a correct site and Javascript support is enabled in your browser and then try again

To resolve the above error..apart from trying the below mentioned steps, just add your website details in trusted websites under Internet options>Security>Trusted Sites. 

1. On the Tools menu, click Internet Options, and then click the Security tab.
2. Click the Internet zone.
3. If you do not have to customize your Internet security settings, click Default Level. Then do step 4

If you have to customize your Internet security settings, follow these steps:
a. Click Custom Level.
b. In the Security Settings – Internet Zone dialog box, click Enable for Active Scripting in the Scriptingsection.

4. Click the Back button to return to the previous page, and then click the Refresh button to run scripts.

unable to load the package as xml because of package does not have a valid XML fomat

Hi Folks,
I was not able to run the ssis job which was pointing to a dtsx file placed in different folder.
I was actually using the below type of file sysmte
C:\MyFolder\Mypackage.dtsc

But we have to use the below one

\\servername\C$\Myfolder\MyPackage.dtsx

SELECT DISTINCT does not work with multiple columns

Hi Folks,
Today I came across a scenario where select distinct did not work when more than two columns are used. To resolve this issue, I used the below type of CTE using Row_Number



;WITH DistinctMails AS

(
    SELECT ID, MailID, EMailAddress, NAME,
        ROW_NUMBER() OVER(PARTITION BY EMailAddress ORDER BY ID) AS 'RowNum'
    FROM dbo.YourMailTable
)
SELECT *
FROM DistinctMails
WHERE RowNum = 1

And it worked !!!

The path of the item 'http://localhost/Reports/Pages/Folder.aspx?ItemPath=/Parent Reports/Child Reports' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash.

Hi folks,
I got the above error after immediately fixing the dataset has to be deployed error while trying to deploy the ssrs report.
The reason for this was I had my report name as Report Check $2,000. All I did was remove the $ sign and the , sign and bingo I was able to deploy the report.

So my suggestion to resolve this error is that you should try not to add any special characters in the name of your reports. 

Cannot deploy the report because the shared data source '/Data Sources/DataSource1' that the report references does not exist on the report server.

Hi Folks,
I was getting the above error and to resolve this error, I first deployed the data source first and then my report.
Find below the screenshots for your reference

Get SSRS report data in single page

Hi,
The SSRS report was showing the data in 2 different pages in print preview page and I needed the whole data in 1 page
To achieve this I followed the below steps

Right click on Report page and click on Report Properties. You should see the below screen.
Increase the width and height and you should get the columns in 1 page

Missing SSIS toolbox visible in 2010 after migrating my SSIS package from 2008 to 2012

Hi Folks
I followed the below link to get the missing SSIS toolbox visible in 2010 after migrating my SSIS package from 2008 to 2012


http://www.jamesserra.com/archive/2013/01/ssis-2012-empty-toolbox/