|
|
-
|
|
I have several posts on how to pass parameters to
1) an OLE DB source in a data flow and
2) to an Execute SQL Task with OLE DB connection.
For case 2), the key is to use the correct mark for the passed in parameter. Different connection types demand different ways to mark the parameters.
For cas......
|
|
-
|
|
I recently needed to modify an SSIS package to add a few new columns to a table.
But I turned out that I had more than just adding columns to do.
I did three things prior to adding the columns:
I added three Sequence Containers as part of the Control Flow, and make t......
|
|
-
|
|
Early this year, I had a post on
SSIS – Pass a variable to a OLE DB Source in a Data Flow. Being able to
make your ETL process dynamic by using dynamic variables will make you appreciate
SSIS more, and enjoy working with it more.
In this pos......
|
|
-
|
|
In my previous post,
SSIS #97 – When MERGE JOIN is your friend?, I showed you a scenario where
Merge Join can be you real friend in your ETL work. I also showed you two ways to
satisfy the sorting requirement by the Merge Join task.
One of t......
|
|
-
|
|
What does Merge Join in SSIS do?
Merge Join task in SSIS is actually a very straightforward task to use, if you know this:
The Merge Join Transformation joins two data sets on a common key (or keys).
It is the same as performing an SQL Join – the options you have are Inner Join, Full Oute......
|
|
-
|
|
I am back from vacation, and have spent a couple of weeks catching up my workload. Now I am ready to finish the SQL Server BI Quiz “Mass Mailing Your Report”.
Here is my original blog, SSRS #55 – SQL Server BI Quiz “Mass Mailing Your Report”. Thanks to the following re......
|
|
-
|
|
SSAS has two major functions:
a high-performance cubing technology, and
a data-mining technology
......
|
|
-
|
|
Here are the steps you can take to create an SSAS database using BIDS.
Create an SSAS project in BIDS.
Create a data source (DS) that connects to your data warehouse in star schema.
Create a data source view (DSV) to act as a layer between your data source and the data warehouse and to protect......
|
|
-
|
|
A data warehouse is made of fact and dimension tables.
Fact tables: hold measures, which are the numeric columns that you want to put on the report.
Dimension tables: hold the columns in which you want to filter the data.
SSAS adopts many of the same items but has changed their names.
Meas......
|
|
-
|
|
Assuming that now we’ve loaded our data warehouse. The rest of my notes are all about SSAS.
SSAS is a service that can pre-aggregate data and make it faster to query data. According to the workshop presenter, it took only 2 seconds to query a 24 terabytes data (in grocery industry)
Reduce ......
|
|