I've different databases configured. Consider as DB1 contains records from 2010-01-01 to 2010-12-31. DB2 contains records from 2011-01-01 to 2011-12-31. DB3 contains records from 2012-01-01 to 2012-12-31.
In UI having dropdown to select the any one of the database. Based on selection the respective DB will be hit to fetch the records and the result will be shown in SSRS report.
What I would like to do is that I want to get records from more than one databases at a time and show the report. Is is possible or achievable?
I know by joining more databases and make it as single DB it is possible. But I look for other opions because I'm not supposed to do that.
Lessons learned during ten years of interviewing for SQL Server Integration Services (SSIS) and other Extract-Transform-Load (ETL) contract roles and two years of staff manager interviewing contractors.
Here's a requirements document template for an integration project (also known as Extract-Transform-Load or ETL) based on my development experience as an SQL Server Information Services (SSIS) developer over the years.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred.
This will be demonstrated using Adobe Premiere Pro CS6.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365.
Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…