Geeks With Blogs
Jim Giercyk April 2012 Entries
SSIS Debugging Tip: Using Data Viewers
When you have an SSIS package error, it is often very helpful to see the data records that are causing the problem. After all, if your input has 50,000 records and 1 of them has corrupt data, it can be a chore. Your execution results will tell you which column contains the bad data, but not which record…..enter the Data Viewer. In this scenario I have created a truncation error. The input length of [lastname] is 50, but the output table has a length of 15. When it runs, at least one of the records ......

Posted On Friday, April 13, 2012 9:03 AM

Controlling soft errors and false alarms in SSIS
If you are like me, you dread the 3AM wake-up call. I would say that the majority of the pages I get are false alarms. The alerts that require action often require me to open an SSIS package, see where the trouble is and try to identify the offending data. That can be very time-consuming and can take quite a chunk out of my beauty sleep. For those reasons, I have developed a simple error handling scenario for SSIS which allows me to rest a little easier. Let me first say, this is a high level discussion; ......

Posted On Tuesday, April 10, 2012 11:16 AM

Adding a DLL to the GAC in Windows 7
I recently created a DLL and I wanted to reference it from a project I was developing in Visual Studio. In previous versions of Windows, doing so was simply a matter of dropping the DLL file in the C:\Windows\assembly folder. That would add the DLL to the Global Assembly Cache (GAC) and make it accessible in Visual Studio. However, as is often the case, Window 7 is different. Even if you have Administrator privileges on your machine, you still do not have permission to drop a file in the assembly ......

Posted On Monday, April 9, 2012 10:34 AM

Working with packed dates in SSIS
One of the challenges recently thrown my way was to read an EBCDIC flat file, decode packed dates, and insert the dates into a SQL table. For those unfamiliar with packed data, it is a way to store data at the nibble level (half a byte), and was often used by mainframe programmers to conserve storage space. In the case of my input file, the dates were 2 bytes long and represented the number of days that have past since 01/01/1950. My first thought was, in the words of Scooby, Hmmmmph? But, I love ......

Posted On Tuesday, April 3, 2012 1:17 PM

Looking under the hood of SSRS
SSRS is a powerful tool, but there is very little available to measure it’s performance or view the SSRS execution log or catalog in detail. Here are a few simple queries that will give you insight to the system that you never had before. ACTIVE REPORTS: Have you ever seen your SQL Server performance take a nose dive due to a long-running report? If the SPID is executing under a generic Report ID, or it is a scheduled job, you may have no way to tell which report is killing your server. Running this ......

Posted On Monday, April 2, 2012 3:27 PM

Copyright © Jim Giercyk | Powered by: