February 8, 2016 at 11:48 am
Several years ago I created an SSIS (Integration Services) package which copies the data from views in our transaction processing database into tables in our reporting database. The job runs every night, in a few minutes, updating all of the tables. It began with a handful of views, but has grown to about 130.
Each of the views has one container with two steps: truncate the existing data table and a data transform which copies from the OLTP db view into an identically formatted table in the reporting db. There is no logic or selection.
The number of views is growing, adding new views and new fields to existing views. Does anyone know of a tool a non-SQL programmer could use to automatically update the package?
We are using SQL Server 2012 SP3.
Thank you for any advice.
February 8, 2016 at 12:00 pm
Take a look at this: 'Stairway to BIML[/url]'
It will take an investment of your time to get up to speed, but sounds like it might be ideal in your case.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply