Category Archives: Syndication

Execute Multiple 2008/2005 SSIS Packages with a T-SQL

Posted on February 16, 2012 by MikeDavisSQL

If you want to execute a set of SSIS packages in SQL Server 2008 or 2005, you can do this using T-SQL. First you will  need a table with all of your package names on it. Then a While loop … Continue reading →

Posted in SSIS, Syndication, T-SQL | Tagged | 6 Comments

Sorting a String as a Number with T-SQL and SSIS

Posted on January 23, 2012 by MikeDavisSQL

I was working on a Cube in Analysis Services for a client recently and needed to sort on a field that was a varchar but contained numeric data. I wanted to sort as if it was numeric. I could not … Continue reading →

Posted in SSIS, Syndication, T-SQL | Tagged , | 2 Comments

How to hide Calculated Members in MDX SSAS

Posted on October 29, 2011 by MikeDavisSQL

With some calculated members in MDX it only makes sense to see the calculation if a certain Hierarchy is used. For example: Aggregate(YTD([Date].[Calendar].CurrentMember),[Internet Sales Amount]) This calculation only works in the Date.Calendar Hierarchy. I wanted to show the end users … Continue reading →

Posted in mdx, SSAS, Syndication | Tagged , | 4 Comments

Setting up SSIS Auditing Part 2

Posted on October 21, 2011 by MikeDavisSQL

Auditing in SSIS can be a real headache. In this two part series blog I am going to try to make it a little easier. You can also download my white paper and sample files on Auditing SSIS here. You … Continue reading →

Posted in SSIS, Syndication | Tagged | Leave a comment

Setting up SSIS Auditing Part 1

Posted on October 17, 2011 by MikeDavisSQL

Auditing in SSIS can be a real headache. In this two part series blog I am going to try to make it a little easier. You can also download my white paper and sample files on Auditing SSIS here. You … Continue reading →

Posted in SSIS, Syndication | Tagged | 1 Comment

Using Configuration Tables in SSIS 2008/2005

Posted on October 4, 2011 by MikeDavisSQL

SSIS packages are great ETL tools and can do just about anything you need in terms of ETL. Most organizations start out creating SSIS package one by one until they have dozens, hundreds, or even thousands of packages. I have … Continue reading →

Posted in SSIS, Syndication | Tagged , , | Leave a comment

Creating your first Data Mining Structure and Model

Posted on September 30, 2011 by MikeDavisSQL

Data mining is a great way to help your company make decisions and predict future values. The Data Mining Algorithms built into SQL Server Analysis Services gives you this power. The Adventure works data base comes with views that are … Continue reading →

Posted in Data Mining, SSAS, Syndication | Tagged , | 1 Comment

SSIS For Each Column in a Data flow

Posted on September 30, 2011 by MikeDavisSQL

Previously I wrote a blog on how to do a for each loop to look through each col in an SSIS data flow here. Well things have changed since I wrote that blog, in fact I believe that old  code … Continue reading →

Posted in SSIS, Syndication | Tagged | Leave a comment

Getting Previous Row in SSIS Data Flow

Posted on September 29, 2011 by MikeDavisSQL

There is no native function built in to SSIS to get the previous row in the data flow. But with a little work you can do this and make it perform much better than a SQL cursor and you don’t … Continue reading →

Posted in SSIS, Syndication | 1 Comment

SSIS Merge with Duplicate Rows

Posted on September 29, 2011 by MikeDavisSQL

The Merge component in SSIS will take two sorted sources and union them while maintaining the original sort order. The question arises, what about duplicate records. These duplicates do not get eliminated. Here are two tables with the ID 5 … Continue reading →

Posted in SSIS, Syndication | Tagged , | Leave a comment