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: SSIS
SQL301-ETL With SSIS, Part 4
We’re back to our ETL with SSIS project, and today we’re going to pick up with transforming the data from our raw format to the final destination for our contact data. So far we’ve scanned a directory for files matching a certain pattern. After finding a file matching that pattern we set up some variables,…
SQL 301-ETL With SSIS, Part 3
Ok, so in our SSIS package we currently have all our variables set up, we have a for each loop that will look in a certain folder for all files matching a certain file pattern. Inside that loop we have a script that will build our archive path and error paths. Next we need to…
SQL 301 – ETL With SSIS, Part 2
In my last post on SSIS, I started you into developing an ETL solution with SSIS. I walked you through setting up your solution, renaming the package, and setting up the variables we would use during the rest of these lessons. Today, we’ll pick up with a Foreash Loop Container. In most case, you’re going…
SQL 301 – ETL With SSIS, Part 1
I’ve discussed SSIS on this site before, but I’ve heard the feedback, you want real world examples. So, I decided to use the business case I address most often using SSIS, and that’s Exchange Transformation and Load. Let’s dive right in to this problem. You receive a file via FTP from a vendor every day. …
Business Intelligence Concepts
The phrase business intelligence is pretty old, 1958. In the early 90’s the term came to refer to the “concepts and methods to improve business decision making by using fact based systems.” So business intelligence is the means for taking all of the data in your organization and pull out the relationships. By finding these…
SQL Session – Migrating From DTS to SSIS
If you’re not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the SQL Server community in Charlotte, NC. Their plan is to get together once a month and discuss a new and interesting topic on SQL Server….