Category Archives: SSIS

  1. Finding active DTS packages

    Leave a comment

    November 27, 2013 by Kenneth Fisher

    DTS is dead, long live SSIS. Way back when SQL 2005 was announced then released DTS was pronounced DOA. SSIS …
    Continue reading

  2. Using DTEXECUI to generate a DTEXEC command line statement the easy way

    2

    July 31, 2013 by Kenneth Fisher

    SSIS is one of those tools that I love and hate at the same time. It’s a great ETL tool …
    Continue reading

  3. Copying Connection Managers in SSIS

    Leave a comment

    December 10, 2012 by Kenneth Fisher

    Did you know you can copy and paste connection managers in SSIS? While I haven’t found this a huge benefit …
    Continue reading

  4. Looping through multiple servers in SSIS Part 3

    14

    November 15, 2012 by Kenneth Fisher

    Over the last couple of weeks I’ve set up a SSIS package that will loop through a group of servers …
    Continue reading

  5. Looping through multiple servers in SSIS part 2

    Leave a comment

    November 9, 2012 by Kenneth Fisher

    Last week I posted a quick example of looping through multiple servers using SSIS and being in a bit of …
    Continue reading

  6. A review of Knight’s 24-Hour Trainer Microsoft SQL Server 2008 Integration Services

    1

    November 7, 2012 by Kenneth Fisher

    About three years ago my manager came up to me and said “We need someone to learn SSIS, you’re it.”  …
    Continue reading

  7. Looping through multiple servers in SSIS

    9

    October 31, 2012 by Kenneth Fisher

    This is just a quickie post to answer a question on how to loop through multiple servers in SSIS.  There …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 293 other followers