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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply