THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server 2008 » SSIS   (RSS)
Showing page 1 of 3 (29 total posts)
  • SQL Server Configuration timeouts - and a workaround [SSIS]

    Ever since I started writing SSIS packages back in 2004 I have opted to store configurations in .dtsConfig (.i.e. XML) files rather than in a SQL Server table (aka SQL Server Configurations) however recently I inherited some packages that used SQL Server Configurations and thus had to immerse myself in their murky little world. To all the people ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 30, 2011
  • High Performance Dimensional Data Loads With SSIS Presentation

    Just finished giving the SSIS High-Performance Dimensional Data Load presentation at SQLSaturday #59 NYC.  Here are the slides in PDF format.  I'll upload the Try-N-Save code and sample data later for attendees to play with. Thanks to everyone who attended my session and thanks to Melissa D. and NJSQL for putting this ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on November 20, 2010
  • Virtual Classes

    I have two online classes starting on November 1st that I recorded on the vClass platform. The first is “Introduction to SQL Server Replication” and is a 12 session class on all things replication. Cost is $199……for more information or to register, click here: The second class is ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on October 26, 2010
  • SSIS Virtual Class

    I recorded a Virtual SSIS Class with the good folks over at SSWUG and the first airing of the class will by May 15th. This is 100% online so you can do it on your own time and from anywhere. The class will run monthly and I will be available for questions through out. You get the following 12 sessions on SSIS, each about an hour. Session 1: The ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on May 13, 2010
  • It's Official - SQLSaturday is Coming to NYC!

    New Jersey SQL Server User Group (NJSQL) is bringing SQLSaturday #39 to NYC on April 24, 2010!  The free all-day training event will be hosted by Microsoft at their Midtown Manhattan offices.  The speaker line-up is growing fast—if you'd like to present, visit the event's open call for speakers.  This is a free full-day ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on February 6, 2010
  • The Trouble with SSIS Sorting

    Many SSIS transformations, such as the Pivot and the Data Profiling Tasks, require that the data being fed into them be sorted. Without first sorting, some transformations will throw an error and not run, while others will run but the results will not be as expected. The answer is to sort the data before it is fed into the transformation; the ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on February 3, 2010
  • SSIS: Mo' Secure Configurations

    I ran into an issue the other day and I needed a solution for automically configuring my SSIS packages from securely stored DBMS connection strings. Problem is that most DBMSs don’t support Integrated Authentication—they require a username and password. Storing the username/password combo in the connection string in plain text is a security risk, ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on January 18, 2010
  • Understanding the SSIS Package Protection Level

    One property of all SSIS packages that you must understand is the ProtectionLevel. This property tells SSIS how to handle sensitive information stored within your packages. Most commonly this is a password stored in a connection string. Why is this information important? If you don’t set the ProtectionLevel correctly, the package may become ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on January 12, 2010
  • Check Out My SSIS Screen Casts

    Two I did for TechTarget: Using the Pivot Transformation in SQL Server Integration Services:,297151,sid87_gci1374920,00.html Using package configurations in SQL Server Integration Services:,297151,sid87_gci1369995,00.html
    Posted to Eric Johnson (Weblog) by ejohnson2010 on December 14, 2009
  • SSIS Package Builds

    So you have written an SSIS package and now its time to package it up and send it off to your QA department. Excellent; you need to use the build function in Business Intelligence Development Studio. On the surface this is pretty simply but there are a few things to understand. You can’t just right click your project and select Build, or even use ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on December 8, 2009
1 2 3 Next >
Privacy Statement