Author: Bradley Schacht

7

Server ‘SERVERNAME’ is not configured for RPC

I recently was doing some development on my local machine and needed to pull data from a linked server.  I set up the linked server and everything was working great.  Executing queries to pull the data to my machine was...

0

Open File – Security Warning in SSIS

When running packages that contain executable and batch files you may sometimes come across an issue where you need to confirm that you want to open the file. This can cause an issue if you run the package unattended. Obviously, this...

Removing The Date From The End of a String 0

Removing The Date From The End of a String

Occasionally there may be the need to remove the date from the end of a string.   This can be accomplished by using PATINDEX along with SUBSTRING.  We will use PATINDEX to find where the date begins and then SUBSTRING to remove the...

0

Joining Tables That Contain NULL Values

As you can see we have two tables, with the same values. Joining on these tables is no problem at all.  Simple, right?  Well, take a look at what happens when we try to join on the column containing the NULL values....

Calculate the Date of Previous Sunday 2

Calculate the Date of Previous Sunday

There are a number of ways that you can calculate dates using T-SQL.  A common practice is to find the first day of the week which can be accomplished easily by using the following function. SELECT DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0) However,...

0

Use SQL from the Command Line

More often than not an execute SQL task in SSIS will do the trick.  If not, then the data flow will accomplish whatever objective is set out.  Occasionally those can become cumbersome in a package to accomplish something simple.  In...

0

Why Won't My .dbf Destination Work

This past week I ran into an issue where I needed to use a .dbf destination in my SSIS package. All was going well; I set up the destination and pressed the preview button to make sure everything was great,...

0

Prepare To Install Reporting Services

The first step in setting up a report server is getting Reporting Services installed.  There are a few differences between the process for 2005 and 2008.  On the installation side, if you do not have the IIS setting configured before...

Control Flow vs Data Flow 1

Control Flow vs Data Flow

After my first day of SSIS training my boss walked into the office and said to me, “how was the first day of class”.  To which I responded, “great!”  Then asked me, “so what is the difference between the control...