Import UTF-8 Unicode Special Characters with SQL Server Integration Services As you work with large scale SQL Server Integration Services ETL processes and sequences, you are bound to have to work with UTF-8 encoded text files. Without proper handling, UTF-8 / Unicode characters can cause havoc with your SSIS load tasks. What are some ideas for handling the UTF-8 file formats with SSIS? Check out this tip to learn more.
Different ways to execute a SQL Server SSIS package One of the Junior SQL Server Developers in my company approached me yesterday with a dilemma. He was developing an SSIS Package which imports data from a comma separated text file and he wanted to know the different ways in which one can execute an SSIS Package in SQL Server 2005 and higher versions. At first I started to tell him, but figured it would be smarter to document the options and share the information.
Taking on your first SQL Server Business Intelligence project SQL Server Analysis Services has been around for quite some time, but for some reason there are many of us who still have not taken the steps to implement Analysis Services. In this webcast, we will discuss various aspects of implementing Analysis Services such as the data model, the terminology, the SQL Server toolset and we also walk through an example of how you can get up and running with a lot less effort than you ever imagined.