In my last post, we used the Import and Export wizard to create a simple Load process. We loaded names.csv into a simple table. Let’s open Visual Studio 2008 (Also known as Business Intelligence Development Studio when you’re talking about the version that comes with SQL Server 2008 R2. Once you’ve started it, open the…
Tag: ETL
Code Review
I’d like to start a new series that will help you learn some of the techniques I’ve used in the past. Some of these techniques are useful, some aren’t. Using SQL is a constant learning process. You have to be willing to look at your solutions and throw out those ideas that no longer work…