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