Welcome to Agile BI Community Sign in | Join | Help

Browse by Tags

All Tags » SSIS   (RSS)

Developer Gaps

I’ve been meaning to post about this ever since I saw Jamie’s post on “ The SQL Developer Gap ”. I couldn’t agree more with what Jamie expressed. Prior to getting into serious BI development, I was primarily an application developer. This was at a time Read More...
Posted Thursday, March 18, 2010 2:40 AM by jwelch | 0 Comments

Slides From the Columbia Code Camp

Thanks to everyone who made it out to the Columbia Code Camp this weekend, even with the sleet and snow in the area. I had a number of requests for the slides from my presentations, so I’ve uploaded them to my SkyDrive. Introduction to SSIS ( SpeakerRate Read More...
Posted Tuesday, February 02, 2010 12:41 AM by jwelch | 0 Comments
Filed under: ,

Slides From “Processing Flat Files with SSIS”

Thanks to the Columbia Enterprise Developer’s Guild for letting me present last night. The audience was great, and I got a lot of good questions. Several people asked if the samples could be made available, and I also had a request to post the slides Read More...
Posted Friday, January 15, 2010 2:53 AM by jwelch | 2 Comments

A New Year and Upcoming Presentations

It’s a new year, and already a lot going on. The new job is going well, but keeping me extremely busy. I’ve got several upcoming presentations, and there’s a SQL Saturday event planned for Charlotte in March that I’m helping organize. I’m also happy to Read More...
Posted Saturday, January 09, 2010 3:18 AM by jwelch | 0 Comments
Filed under: ,

Performance of Raw Files vs. Flat Files

It’s pretty well accepted that raw files in SSIS are a very fast means of getting data in and out of the pipeline. Jamie Thomson has referenced the use of raw files a number of times and Todd McDermid recently posted about using them for staging data Read More...
Posted Monday, December 14, 2009 2:00 AM by jwelch | 5 Comments
Filed under: ,

Implementing PerformUpgrade in Custom Components

If you develop custom components for SSIS, you may have the need to update them as you add new functionality. If you are just upgrading the functionality, but not changing the metadata, then you can simply recompile and redeploy the component. An example Read More...
Posted Monday, September 28, 2009 2:21 AM by jwelch | 0 Comments

Quick Tip for Specifying Columns in Source Components

It’s generally accepted* that when you are using an OLE DB Source or an ADO.NET Source, you should specify all the columns, rather than selecting the table from the dropdown, or using a SELECT * SQL statement. If you’re like me, then you probably don’t Read More...
Posted Tuesday, June 30, 2009 12:02 AM by jwelch | 0 Comments
Filed under: ,

Warning about Using String Variables in Derived Column Expressions

I ran across an interesting behavior in SSIS this week, and thought it was worth sharing. Occasionally, I’ll have the need to use the value of a variable (set in the control flow) in the data flow. The typical way to accomplish this is to use a Derived Read More...
Posted Sunday, June 28, 2009 11:14 PM by jwelch | 0 Comments
Filed under: , ,

Setting “Work Offline” without Opening the Project

If you’ve done much work with SSIS, you’re probably aware that on opening a package in BIDS, SSIS validates all the objects in the package. This can cause the packages to open very slowly, particularly if it has connections to a database that is currently Read More...
Posted Tuesday, May 12, 2009 7:12 PM by jwelch | 3 Comments
Filed under:

Updating Custom Assembly References in SSIS

Just a quick tip related to a recent problem I had with a custom task I developed for SSIS. I had to recompile it recently, and in the process, managed to change the public key associated with the assembly. Since SSIS uses strong names (which include Read More...
Posted Friday, March 27, 2009 8:34 PM by jwelch | 2 Comments

Check for SQL Agent Job Completion

Recently, a user on the MSDN forums asked how to check an Agent job from SSIS to see if it’s completed. Once it had completed, additional steps need to be performed, for example, archiving flat files. However, this couldn’t be done till the job completed. Read More...
Posted Friday, February 20, 2009 9:04 PM by jwelch | 1 Comments
Filed under: ,

SSIS Event Handlers

There was a question recently by a fellow MVP, who was wondering if the event handlers in SSIS were fired synchronously or asynchronously. The answer (which I double-checked with Matt Masson ) is that they are synchronous. When events are fired asynchronously, Read More...
Posted Monday, December 08, 2008 2:57 PM by jwelch | 0 Comments
Filed under: ,

SSIS Tasks and Components

Todd McDermid (a frequent poster on the MSDN SSIS forums , and creator of the Kimball SCD component ) and I have started a new project on CodePlex along with Todd McDermid, the SSIS Community Tasks and Components (ssisCTC) project. This project is intended Read More...
Posted Friday, November 07, 2008 9:24 PM by jwelch | 0 Comments
Filed under: , ,

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 | 2 Comments
More Posts Next page »