This is my third year attending the Jacksonville SQL Saturday but this will be my first year there as a presenter. There’s a lot of talented database professionals in Jacksonville and I’m honored to have this opportunity. The topic I’ll be covering is Maintaining Indexes. It’s an entry-level topic and my first time presenting it, so it should be interesting to see how people react to it. SQL Saturday 215 will be on April 27th.
I’ve been selected to speak at Orlando Code camp on March 16th. Again I’ll be covering the topic of Automating Processes with SSIS. I had a great time last year at Code Camp and I’m really looking forward to presenting again this year. I’m hoping this topic in particular can be something that .NET developers might be interested in leveraging.
Okay, I’ll admit that this post is a bit of a cop-out but if you landed here then you’re most likely having some troubles getting SSIS and Excel working correctly with some error regarding the usage of 64-bit drivers. Rather than going through each of the possible solutions, I’ll refer you to another blog that has links to several other blogs with several solutions. Each solution is different depending on your environment and your needs. In general, I try to avoid using Excel at all with SSIS and prefer to use CSV’s. Most business users can be convinced to save their data as CSV and it’s much more friendly for SSIS to process. It also removes all kinds of funky formatting that users love to throw in spreadsheets.
I’ve been selected as a speaker for SQL Saturday 192 in Tampa, FL. I’ll be presenting Automating Processes with SSIS for the first time. In this presentation we’ll take a real world example and use SSIS to automate tasks such as file copying, encryption, imports, and exports. This is a good demonstration of using SSIS’s expressions, variables, and scripts to achieve tasks.