|
|
-
|
|
I’ve written one post about SSIS – Enable Package Configuration for Deployment, and another one about SSIS – Add Configuration Files for Deployment.
I am afraid that after reading these two posts you are quite confused. You are probably screaming silently. Why is she talking abou......
|
|
-
|
|
The employee hierarchy table is just one physical table, with a date range to keep employee’s employment history. This same employee hierarchy table can be used sometimes to show different business functional teams, for example, LAS VS. Underwriters on the same fact table.
I can simply creat......
|
|
|
|
-
|
|
Here is the procedure that “waits for”.
......
|
|
-
|
|
if(datename(dw, getdate()) in (‘Sunday’, ‘Monday’))
raiserror(‘it”s Sunday or Monday, skipping F report’, 11, 1)
......
|
|
-
|
|
I came back to my old job, but am not working on exactly same projects. I am very happy that I have new puzzles to solve now.
Obviously employee compensation and productivity reporting has become a hot topic in the business recently.
I am going to blog on this subject as I get to understand more a......
|
|
-
|
|
Continuing from my previous post SSIS – Pass a list of values to a data flow source.
Step 3: create a user defined function on DB2 to convert the list of the Status IDs into rows.
Now I need to have a function on DB2 to convert the list of the Status IDs into rows.
Actually I really need 2 ......
|
|
-
|
|
I wrote a blog post SSIS – Use “Foreach Loop Container” and pass a variable to a OLE DB Source in a Data Flow a few days ago.
But when do we really need the Foreach Loop Container? I find that I do not use it very often. The reason is that I can only pass one at a time the value o......
|
|
-
|
|
I have been working with SQL Server, and Integration Services and Reporting Services for years. Data from our data warehouse in DB2 are ETL’d to the SQL server to be ready to be consumed by SSRS report. Until recently, I’ve only been using unique key constrains on the fact tables sparsel......
|
|
-
|
|
If you have experience with writing SQL codes, but SQL is not your primary job, you might get a feeling that you are almost there as an expert, but sometimes, you just cannot seem to reach a very straightforward goal.
Recently a business process analyst came to me for some SQL tips.
Here is the ch......
|
|