Monthly Archives: May 2011

Copy Data Dynamically with BimlScript

This post is part 3 of a series on using Biml in BIDS Helper. This post builds on some of the information and the sample from the previous posts. BimlScript enables some interesting scenarios for generating large numbers of SSIS … Continue reading

Posted in SSIS | Tagged , , | Comments Off

Creating Tables using Biml and BimlScript

Create tables using Biml and BimlScript Continue reading

Posted in SSIS | Tagged , , , | Comments Off

How to Extract SAP Data in SSIS

This tutorial will step you through installing the Microsoft SAP ADO.Net connector and extracting data from SAP, all via SSIS. But first, some background information. Overview This week brought me the unique challenge of extracting data from SAP within SSIS. … Continue reading

Posted in Uncategorized | Tagged , | Comments Off

Submissions for PASS Summit 2011

PASS Summit 2011 Abstracts Continue reading

Posted in PASS | Tagged , | Comments Off

Biml Functionality in BIDS Helper

If you follow along with the BIDS Helper project on CodePlex, you may have noticed that we released a new beta version on April 20th. The new build includes some bug fixes, and two new features. Duplicate Role (SSAS) The … Continue reading

Posted in SSIS | Comments Off

Creating a Basic Package Using Biml

Create an SSIS package using Biml in BIDS Helper Continue reading

Posted in SSIS | Tagged , , , | Comments Off

Presenting at Carolina Code Camp 2011

Presenting SSIS topics at the Carolina Code Camp this weekend Continue reading

Posted in Events | Tagged | Comments Off

XML as Source in SSIS — Part 2

Now that our data is cleansed, onto loading the data into our table! The cleanest, most sane approach that I have found to parsing through XML within a SSIS script task is by utilizing Linq to XML. More information can … Continue reading

Posted in Uncategorized | Tagged , | Comments Off

XML as Source in SSIS

XML is becoming increasingly popular in the workplace. Many systems are using it as a way to transmit data efficiently across the network. While XML certainly has its place, consuming it and deconstructing it can be a real headache. Unfortunately, … Continue reading

Posted in Uncategorized | Tagged , | Comments Off

Tuning SSAS Processing Performance

Guide to tuning SSAS processing performance Continue reading

Posted in SQL Saturday, SSAS | Tagged , | Comments Off