SQLKover update: nowadays you would probably use package parameters to pass the directory value. However, they still have a default value, so this still applies. Recently I ran across a forum thread where someone encountered an unexpected result when creating a directory using the File System Task in Integration Services. He used a variable to […]
Tag: reblog
Reblog: MDS – A Database Error Has Occurred
I recently came across the following error message when I tried to look at the batches in the Integration Management section of MDS: 515: A database error has occurred. Please contact your system administrator Too bad I am the system administrator on that machine… Anyway, after some searching it came out the MDS stored procedure […]
Reblog: SSIS Performance Testing
I had to do some performance testing for an MSSQLTips article and I thought I’d share the framework I used in a blog post. First of all we have to log start and end dates of the package to a table so we can easily calculate the duration a package took to finish. This can probably […]
Reblog: Building the Script Component
SQLKover update: For some reason, this was my most popular blog post on the old LTD site. Over 110,000 views. People must be building them script components. The problem From time to time I have to script out some logic using a Script Component in a SSIS package. Business as usual for most developers, but since […]
Reblog: Slow source? Make your data flow buffers smaller!
Whoa whoah. Aren’t you supposed to increase your data flow buffer size in order to speed up your packages? If you have enough memory and you can process more rows at the same time because your buffer is larger, that’s what we want, right? Yes, this is confirmed by the old blog post Adjust buffer […]
Reblog: The OLE DB Source and the Oracle Date Literal
SQLKover update: when of the stranger Oracle issues I encountered over the years. Some time after I published the original blog post, there was a forum question about the same issue. I googled and found my own blog post as the answer. Recently I was developing an SSIS package in BIDS 2008R2 which was part […]
Reblog: The shaky bug in SSIS
SQLKover update: I’m reblogging this a bit earlier (it’s a quite recent blog post) because I still see people with this issue. Also, it seems that sometimes the fix doesn’t work. You may or may not have noticed it after installing SQL Server 2012/2014: the designer interface in Visual Studio 2010/2012 has had a make-over. Nothing […]
Reblog: Star Schema The Complete Reference – Review
SQLKover update: 1.5 year later, I still stand by my position: Star Schema The Complete Reference is the best book on dimensional modelling around. Recommended/obligatory reading! I finished my first book of this year and here’s the review! After I finished the newest edition of Ralph Kimball’s Data Warehouse Toolkit, a senior colleague of mine recommended […]
Reblog: What’s the deal with Excel and SSIS?
SQLKover update: When I read this old blog post of mine, all I can think about is: Power Query to the rescue! When it comes to importing data from an Excel sheet with SSIS, Excel has quite a reputation. And not a terribly good one. Well deserved, to be honest, because numerous issues can rise […]