Author Archives: MikeDavisSQL

Setting Parameters in SSIS at Run time

Posted on August 26, 2019 by MikeDavisSQL

In SSIS when you are running a package with a parameter I find myself wanting to set the Project Parameters at run time. You can do this by creating an Enviroment Variable and then running the below script to set … Continue reading →

Posted in Uncategorized | Leave a comment

Create Date Dimension with Fiscal and Time

Posted on October 2, 2015 by MikeDavisSQL

Here are three scripts that create and Date and Time Dimension and can add the fiscal columns too. First run the Dim Date script first to create the DimDate table. Make sure you change the start date and end date … Continue reading →

Posted in Uncategorized | 1 Comment

Make an SSIS package Delay or Wait for Data

Posted on July 21, 2014 by MikeDavisSQL

Packages can be scheduled to run at a time when you expect data to be in a database. Instead of guessing the time when the data will be in the database we can have the package look for data in … Continue reading →

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

SSIS XML Task

Posted on April 7, 2014 by MikeDavisSQL

The XML Task in SSIS allows you to parse through an XML file and read the nodes in the XML. In a previous blog I showed how to use a web service task to get the city and state when … Continue reading →

Posted in SSIS, Syndication | Tagged | Leave a comment

SSIS Web Service Task

Posted on March 31, 2014 by MikeDavisSQL

The Web Service task in SSIS can be used to call a web service command to perform a needed operation in your package. The results of most web services will be in XML Format. You can save these results into … Continue reading →

Posted in SSIS, Syndication | Tagged | 2 Comments

Using Variables and Parameters SSIS

Posted on March 24, 2014 by MikeDavisSQL

When creating an SSIS package it is always a best practice to use variables, and parameters in 2012,  to avoid hard coding values into any part of your package. But there are some best practices involved with creating those variables/parameters … Continue reading →

Posted in SSIS, Syndication | Tagged | 1 Comment

Using Configuration Files in SSIS

Posted on March 17, 2014 by MikeDavisSQL

Now in SQL 2012 we have parameters that make it easy, but configuration files are still an option and I still see a lot of my clients using them even on 2012 due to several reasons, but mostly because of … Continue reading →

Posted in SSIS, Syndication | Tagged | 8 Comments

Two Digit Dates in SQL – MM/DD/YYYY

Posted on March 10, 2014 by MikeDavisSQL

When creating dates or numbers as strings it is sometimes required to have two digit numbers. For example, instead of this: 3/1/2011 You want to see this: 03/01/2011 There is an easy way to do this using the Right() function … Continue reading →

Posted in Syndication, T-SQL | Tagged | Leave a comment

SSRS Top N and Bottom N reporting with Duplicates

Posted on March 3, 2014 by MikeDavisSQL

Previously I wrote a blog on Top N and Bottom N reporting. There were a couple of gotcha I did not cover in that blog so I thought I would cover those here to answer some of the questions I … Continue reading →

Posted in SSRS, Syndication | Tagged | 2 Comments

Standard Deviations with CTE in SQL

Posted on February 24, 2014 by MikeDavisSQL

I was working with a client recently getting the number of standard deviations a student was off the average number of suspensions. I accomplished this with two Common Table Expressions, (CTE). The first CTE gets the standard deviation and the … Continue reading →

Posted in Syndication, T-SQL | Tagged | Leave a comment