Agile BI Community

Community site for agile business intelligence developers
Welcome to Agile BI Community Sign in | Join | Help
in Search

Browse by Tags

All Tags » SSIS
Showing page 1 of 7 (70 total posts)
  • Speaking at the Carolina Code Camp

    I’ll be presenting a couple of sessions at the Carolina Code Camp on Saturday, May 15th. This will be my second time presenting at the Carolina Code Camp, and I’m looking forward to it. Last time, I had great audience participation, and the event was well organized and fun. I’ll be presenting on “Processing Flat Files with SSIS” at 8:45 AM and ...
    Posted to BI Thoughts and Theories (Weblog) by jwelch on May 12, 2010
  • T-SQL Tuesday #006 – LOBs in the SSIS Dataflow

    The topic for T-SQL Tuesday #006 is LOB data, selected by this month’s host, Michael Coles. If you aren’t familiar with T-SQL Tuesdays, Michael has a nice summary in his post. In database terms, LOBs are Large OBjects, also referred to as BLOBS (Binary Large OBjects). These are data types that can exceed the maximum row size of 8 KB in SQL ...
    Posted to BI Thoughts and Theories (Weblog) by jwelch on May 11, 2010
  • Delete Multiple Connection Managers SSIS

    Have you ever wanted to save yourself some time by copying a package, renaming it, and then modifying its contents to suit your needs? What if the package that you are copying from has 60 connection managers, and your new package only needs 1? In SSIS, there is no ability to do a “select all” on the connection managers that you don’t need and ...
    Posted to Musings On ETL (Weblog) by JJames on April 22, 2010
  • 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 when agile development was becoming very popular. As part of that, refactoring, test driven ...
    Posted to BI Thoughts and Theories (Weblog) by jwelch on March 17, 2010
  • 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 link) Creating Custom Components for SSIS (SpeakerRate link)  (the sample ...
    Posted to BI Thoughts and Theories (Weblog) by jwelch on February 1, 2010
  • 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 for some people who weren’t able to make it. So, here they are. I’ve posted them to my SkyDrive ...
    Posted to BI Thoughts and Theories (Weblog) by jwelch on January 14, 2010
  • 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 say that my MVP status was re-awarded for 2010. I have an upcoming presentation at the ...
    Posted to BI Thoughts and Theories (Weblog) by jwelch on January 8, 2010
  • 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. It occurred to me, that even though I’d always heard they were faster than other options, I’d ...
    Posted to BI Thoughts and Theories (Weblog) by jwelch on December 13, 2009
  • 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 of this type of update would be changing the component to do additional warning or ...
    Posted to BI Thoughts and Theories (Weblog) by jwelch on September 27, 2009
  • Adding Custom Components to SSIS

    Below are the basic steps for adding custom components to SSIS; however, for more in-depth information I highly recommend reading Matthew Roche’s post about deploying and testing custom SSIS components. 1. Register the custom assembly in the Global Assembly Cache (GAC) Copy the DLL to the c:\windows\assembly\ directory.  Note that you ...
    Posted to The BI Hive (Weblog) by mcole on August 18, 2009
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Personal Edition), by Telligent Systems