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/
 

The flat file parser does not support embedding text qualifier in data...Amazing and simple solution

Hi Guys,
I am trying to migrate from DTS to SSIS and 1 of the task was to import data from text file which had double quotes in it. But I will get the below error

"The flat file parser does not support embedding text qualifier in data". I also noticed that the column delimter was not highlighted in the "Columns" tab

After spending hours to resolve this issue, I found  the solution and it is to Just click on "Reset Column" in your connection manager and you will get the "Column Delimiter" highlighted,

This solution is not available in most of the google blogs

Trim first few characters in SSIS derived column

Hi Guys,

If you want to remove first few characters in a word in one of the column in derived column in ssis then you can use the below statement
REPLACE (<columnname>,"Word to be replaced","")

Example - SUPER_CLIENT in column PORTFOLIO will be replaced by nothing or that word will be removed using the below statement
REPLACE(PORTFOLIO, "SUPER_CLIENT:","")

If Else If and else statement in derived column in SSIS

Hi Guys,
Follow the below statement type to achieve if else if condition in ssis

[MyStringVar] == "TEST1" ? "IT WAS TEST1":
[MyStringVar] == "TEST2" ? "IT WAS TEST2":
[MyStringVar] == "TEST3" ? "IT WAS TEST3":
"MATCH NOT FOUND"