· Krehbiel Tech · Tuesday, Mar 13, 2007, 7:01 PM · 337 words
I thought it would be good to sit down and evaluate where I am with uvBlog in comparison to my stated goals. Points in italics below were my original goals.
· Krehbiel Tech · Thursday, Mar 15, 2007, 8:07 PM · 272 words
I had the "opportunity" to fix someone else's SSIS package that was failing because of a data overflow on a date column at one of the data destination components.
· Krehbiel Tech · Friday, Mar 16, 2007, 4:59 PM · 98 words
To follow up on yesterday's mystery date problem: It turned out that one of the incoming dates had been erroneously entered with the year "1007" instead of "2007." The date was valid on the Oracle data source, and it was valid within the SSIS data flow. However, SQL Server 2000 can't store a date prior to the year 1753, so the data destination failed. I put in a script component to test for dates earlier than 1753, set them to "1/1/1753", and flagged the row with an error. Now all is working without the icky "ignore errors" setting.
· Krehbiel Tech · Tuesday, Mar 27, 2007, 11:04 AM · 258 words
I used to be the kind of person to upgrade software immediately as soon as new versions were available, because it used to be true that upgrades meant there would be some kind of improvement. But lately Microsoft has been working to redefine the term "software upgrade" to mean "an entirely different application rewritten from the ground up without any quality control." First there was Visual Studio 2005, which is definitely quirkier and slower than Visual Studio 2003. Then, in the same vein, there's SQL Server Business Intelligence Studio, which I've had the pleasure of using for a year now. It has one of the slowest and buggiest interfaces in a Microsoft product I've ever seen. How is it even possible that the faster the computer hardware gets, the slower the applications run?
· Krehbiel Tech · Tuesday, Mar 27, 2007, 9:47 PM · 1,306 words
I thought it might be fun to review some of my earlier programming projects on this blog.
· Krehbiel Tech · Wednesday, Mar 28, 2007, 5:33 PM · 160 words
Amazingly enough, I hadn't run across this situation before. I was writing a quick utility to generate a C# class from a database table today, and I discovered that the following code failed.
· Krehbiel Tech · Saturday, Mar 31, 2007, 5:50 PM · 439 words
Today's lesson is about how to avoid those annoying messages that SSIS gives you about being unable to decrypt sensitive data in a package.