Monthly Archives: November 2010

ForEach Loop Container – Continue On Error

Download Sample Package and SQL Files[Extract the zip file – SSISContinueOnError.zip containing SQL Files to C:\EasyBI such that all SQL files reside directly within C:\EasyBI\SSISContinueOnError] Lets say we use For Each Loop Container for looping around a set of files … Continue reading

Posted in SSIS | Leave a comment

Where is SSRS RDL Content Stored in ReportServer Database?

When an SSRS Report (.RDL) is deployed to SSRS Report Server, this is stored in SSRS Database ReportServer tables. To retrieve SSRS RDL from ReportServer DB, use the following SQL by connecting to  Reporting Service SQL server. SELECT [Path], Name, CAST(CAST(Content AS … Continue reading

Posted in SSRS | Leave a comment

Blog on Microsoft BI

Hi, I am Jegan, working as a BI developer in Bristol, UK. This is a blog focussing on BI- specifically Microsoft BI -SSIS, SSRS, SSAS. I will also be covering Automated deployment using MSBuild, Automated testing of SSRS reports & SSIS packages, internals … Continue reading

Posted in Uncategorized | Leave a comment