January 29, 2010 at 7:01 am
Hi,
We have SQL Server 2005 installed on our server.
It is running a SQL Server 2000 procurement database.
I would like to create another database but a 2005 version\compatibility and load reporting tables (datamart) using tables from the
sql 2000 procurement database.We have orderheader table and orderdetail table and want to pull the data into a single table which would de-normalize it for report querying and later will be our datamart (to load datacubes which is the second stage of our project to perform BI analysis on the data)
These reporting tables would be used for the first version of our project.
Using Management Studio I know how to do this by creating a stored procedure that we would call nightly to load the data into the reporting database from scratch, we propose not to do it incremental loads after the initial load as we don't have a lot of data right now.
This stored procedure would require perhaps dozens of queries to finally getting into the reporting format.
Is BIDS 2005 the tool to do this? Does it have the built in functions\features to speed up the development process?
Will integration services let me run what is developed in BIDS to run as a nightly job.
Please note 🙂 I am a newbie to Microsoft BI ecosystem.
Any help would be greatly appreciated.
January 29, 2010 at 7:19 am
BIDS is a BI development tool that can be used to develop reports, SSIS projects which includes ETL and SSAS projects which includes dimension modeling. When your SSIS packages are developed you use the SQL Server Agent to run the JOBs.
Kind regards,
Gift Peddie
January 29, 2010 at 9:45 am
Thanks SSCrazy
January 29, 2010 at 2:26 pm
haggisns (1/29/2010)
Thanks SSCrazy
I am glad I could help.
🙂
Kind regards,
Gift Peddie
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply