Welcome to Agile BI Community Sign in | Join | Help

Browse by Tags

All Tags » SSIS   (RSS)

The Microsoft BI Conference

I'm doing a couple of chalk talks at the Microsoft BI Conference , occurring in Seattle, WA on October 6-8. The chalk talks are a different format than the typical presentation: smaller audience, no (or very few) slides, and more conversational in format. Read More...
Posted Thursday, September 18, 2008 1:58 AM by jwelch | 0 Comments
Filed under: ,

Error Redirection with the OLE DB Destination

A question that comes up occasionally is how to handle errors that occur on the OLE DB Destination in the data flow. Errors that occur when using the OLE DB Destination to insert into a table are usually caused by primary key, foreign key, or check constraints Read More...
Posted Friday, September 05, 2008 8:43 AM by jwelch | 0 Comments

Configuration Approaches In SSIS

A number of the SSIS MVPs were asked to contribute a white paper to MSDN a few months ago, and those articles were published recently. You'll notice a common thread in most of the topics: Considerations for High Volume ETL Using SQL Server Integration Read More...
Posted Sunday, August 31, 2008 1:46 AM by jwelch | 0 Comments
Filed under: ,

Using the XML Task to Run an XPath Query

I came across a question about this the other day, and thought I'd share the answer here, as there doesn't seem to be much information out there about it.  The questioner wanted to know how to read a portion of an XML document into a variable. Fortunately, Read More...
Posted Wednesday, July 23, 2008 2:19 AM by jwelch | 0 Comments
Filed under: ,

Presenting at the SSWUG Virtual BI Conference

I'm going to be presenting a few sessions at the upcoming SSWUG Virtual Business Intelligence Conference . It's occurring from September 24-26, 2008. It has a very impressive list of speakers (I'm really not sure how I made it on the list - it's quite Read More...
Posted Sunday, July 20, 2008 10:28 PM by jwelch | 1 Comments
Filed under: ,

Continuing a Loop After an Error

A common question on the SSIS forums is how to continue a loop after an error occurs. For example, you might have a For Each Loop container that iterates through a set of files in a folder. If one file is invalid, you want to continue processing the remaining Read More...
Posted Sunday, June 29, 2008 1:32 AM by jwelch | 0 Comments
Filed under: ,

Updated Information on 64-bit Considerations for SSIS

Douglas Laudenschlager has posted some good information about the considerations you need to make if you are running SSIS on a 64-bit box. This is additional information to what is currently in Books Online, and it’s well worth looking at. Considering Read More...
Posted Thursday, June 12, 2008 9:09 PM by jwelch | 0 Comments
Filed under: ,

Calculating a Running Total Part 2

To finish up the topic that I started in my previous post , I wanted to post a more complex example of running total calculations. This is based off a request on the MSDN forums, for a running total calculation that would “slide” along as additional rows Read More...
Posted Thursday, June 12, 2008 1:18 AM by jwelch | 0 Comments
Filed under: , ,

Calculating a Running Total In SSIS

Running totals are a common calculation for reporting, and are occasionally needed in ETL processes to populate aggregate tables. One way to accomplish this in SSIS, if you are retrieving data from a relational database, is to do the running total in Read More...
Posted Monday, June 09, 2008 4:33 AM by jwelch | 1 Comments
Filed under: , ,

SSIS Configurations At Design Time

There's an interesting "behavior" that occurs with configurations at design time. The value of the configuration will be saved in your package as the new stored value. I'd seen this before, but never really thought about it, until a poster on the forums Read More...
Posted Wednesday, June 04, 2008 5:58 PM by jwelch | 0 Comments
Filed under: ,

See if a File is Locked

A question that comes up occasionally on the forums is how to determine if a file is being written to by another process. It can cause issues if a file is partially written when a source component starts extracting data from it. There is a way to check Read More...
Posted Tuesday, May 13, 2008 2:41 AM by jwelch | 0 Comments
Filed under: ,

Common Expressions In the Data Flow

I use the Derived Column transform in the Data Flow a lot. In fact, I can't remember the last time I wrote a production package that didn't include at least one Derived Column transform in it. Over time, I've built up a lot of common expressions that Read More...
Posted Saturday, April 26, 2008 10:12 PM by jwelch | 0 Comments
Filed under: ,

Sending an Alert if a Package Runs Too Long

A question that has come up in a few different situations recently is how to send someone an alert if your package is taking too long to execute. For example, you might have a package that loads a large number rows from a source system to a destination Read More...
Posted Sunday, April 20, 2008 11:54 PM by jwelch | 0 Comments
Filed under: ,

RetainSameConnection and Expressions

I ran across a forum post today that highlighted a limitation with connection managers that I wasn't aware of, so I thought I'd post it here. If you have RetainSameConnection set to TRUE, and you are also trying to update the connection string through Read More...
Posted Friday, March 28, 2008 1:20 AM by jwelch | 0 Comments
Filed under: , ,

ssisUnit - A Unit Testing Tool for SSIS

I've been a bit lax posting on my blogs and the MSDN forums recently. Fortunately, I have a good reason (at least I think it's a good one). :) My employer, Mariner , has graciously given me permission to open source a unit testing framework for SSIS packages. Read More...
Posted Wednesday, March 12, 2008 4:09 AM by jwelch | 3 Comments
More Posts Next page »