Apple's visionary and creative genius Steve Jobs

How can I deploy SQL 2008 SSRS Report in to SQL 2005 SSRS Server

Error:
The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded. (rsInvalidReportDefinition) Get Online Help


You can not deploy  sql server 2008 report (rdl) into sql server 2005 report  server because RDL namespace are different for each version.

End of Mainstream Support for SQL Server 2005 and End of Service Pack Support for SQL Server 2008 SP1

Mainstream Support for SQL Server 2005 Service Pack 3 and SQL Server 2005 Service Pack 4 will end on April 12, 2011, and Service Pack Support for SQL Server 2008 Service Pack 1 will end on October 11, 2011. 

Product	Version	SP	Mainstream Support End Date	Extended Support End Date	Options / Notes
SQL Server	7.0	SP4	12/31/2005	01/11/2011	Technical support ends as of 01/11/2011; options for technical and/or hotfix support after this date: ð  Continue with self-help ð   Upgrade to the latest supported service pack for SQL Server 2005 or SQL Server 2008 or SQL Server 2008 R2 ð  Custom support agreement
SQL Server	2000	SP4	04/08/2008	04/09/2013	Technical support continues till 04/09/2013, yet mainstream (hotfix) support ends as of 04/08/2008; options for hotfix support after 04/08/2008: ð   Upgrade to the latest supported service pack for SQL Server 2005 or SQL Server 2008 or SQL Server 2008 R2 ð  Extended hotfix support agreement
SQL Server	2005	RTM (SP0)	07/10/2007	Not applicable	Technical support ends as of 07/10/2007; options for technical and/or hotfix support after this date: ð  Continue with self-help ð  Upgrade to the latest supported service pack for SQL Server 2005 or SQL Server 2008 or SQL Server 2008 R2
SQL Server	2005	SP1	04/08/2008	Not Applicable	Technical support ends as of 04/08/2008; options for technical and/or hotfix support after this date: ð  Continue with self-help ð  Upgrade to the latest supported service pack for SQL Server 2005 or SQL Server 2008 or SQL Server 2008 R2
SQL Server	2005	SP2	01/12/2010	Not Applicable	Technical support ends as of 01/12/2010; options for technical and/or hotfix support after this date: ð  Continue with self-help ð  Upgrade to the latest supported service pack for SQL Server 2005 or SQL Server 2008 or SQL Server 2008 R2 ð  Custom support agreement
SQL Server	2005	SP3	04/12/2011	01/10/2012	Technical support continues till 01/10/2012, yet mainstream (hotfix) support ends as of 04/12/2011; options for hotfix support after 04/12/2011: ð  Continue with self-help ð  Upgrade to the latest supported service pack for SQL Server 2005 or SQL Server 2008 or SQL Server 2008 R2 ð  Custom support agreement
SQL Server	2005	SP4	04/12/2011	04/12/2016	Technical support continues till 04/12/2016, yet mainstream (hotfix) support ends as of 04/12/2011; options for hotfix support after 04/12/2011: ð  Continue with self-help ð  Upgrade to the latest supported service pack for SQL Server 2005 or SQL Server 2008 or SQL Server 2008 R2 ð  Extended hotfix support agreement
SQL Server	2008	RTM (SP0)	04/13/2010	Not Applicable	Technical support ends as of 04/13/2010; options for technical and/or hotfix support after this date: ð  Continue with self-help ð  Upgrade to the latest supported service pack for SQL Server 2008 or SQL Server 2008 R2 ð  Custom support agreement
SQL Server	2008	SP1	10/11/2011	Not Applicable	Technical support ends as of 10/11/2011; options for technical and/or hotfix support after this date: ð  Continue with self-help ð  Upgrade to the latest supported service pack for SQL Server 2008 or SQL Server 2008 R2 ð  Custom support agreement
SQL Server	2008	SP2	See Options/Notes		Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. Visit the Lifecycle page to find the support timelines for your particular product.
SQL Server	2008 R2	RTM (SP0)	See Options/Notes		Support ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. Visit the Lifecycle page to find the support timelines for your particular product.

How to get the database property settings value

--DATABASEPROPERTYEX() Returns the current setting of the specified database option or property

SELECT DATABASEPROPERTYEX('AdventureWorks', 'Collation')
SELECT DATABASEPROPERTYEX('AdventureWorks', 'SQLSortOrder') --0 = Database is using Windows collation
SELECT DATABASEPROPERTYEX('AdventureWorks', 'IsAutoShrink')
SELECT DATABASEPROPERTYEX('AdventureWorks', 'IsAutoCreateStatistics')
SELECT DATABASEPROPERTYEX('AdventureWorks', 'IsAutoUpdateStatistics')
SELECT DATABASEPROPERTYEX('AdventureWorks', 'IsFulltextEnabled')
SELECT DATABASEPROPERTYEX('AdventureWorks', 'IsTornPageDetectionEnabled')
SELECT DATABASEPROPERTYEX('AdventureWorks', 'Recovery')
SELECT DATABASEPROPERTYEX('AdventureWorks', 'Status')
SELECT DATABASEPROPERTYEX('AdventureWorks', 'Version')
SELECT DATABASEPROPERTYEX('AdventureWorks', 'UserAccess')
SELECT DATABASEPROPERTYEX('AdventureWorks', 'IsPublished')
SELECT DATABASEPROPERTYEX('AdventureWorks', 'IsMergePublished')
SELECT DATABASEPROPERTYEX('AdventureWorks', 'IsSubscribed')

How to import packages using Integration Services

There are two different way to import ssis packages either command prompt or SSIS.
Here i am going show you , How to import ssis package via SSIS.

1. connect to SQL Server Integration Services
2. Expand Stored Packages
3. Expand the MSDB
4. Create Folder called My SSIS Packages
5. Import Packages

6. Package Location : File system

7. Package Path : C:\SSMS_Export_to_Excel.dtsx
8. Protection Leve : Rely on the server storage and role for access control

9. Package is imported now as you can see