- This event has passed.
Richmond SQL Server Users Group
August 8, 2019 @ 6:30 pm - 8:00 pm
Geoff Johnson-Working with SSIS Script Component: Some Tips Learned the Hard Way
SQL Server Integration Services is relatively new to me; I started working with it about two years ago. As I have been using the Script Component, I have run into some challenges that I imagine many new users of that tool have also encountered. Now I have a love-hate relationship with the Script Component because it still annoys me in certain ways, but it also makes some transformation steps much easier. In this presentation, I’ll share what I’ve learned while using the Script Component to do conversion projects pulling data from Excel and Access into SQL Server. If you’re just getting started with SSIS and the Script Component, this information should save you some time and frustration. And if you’re an old hand at it, maybe you can help me – and others — overcome those annoying bits.