Category Archives: SSIS
-
Finding active DTS packages
2November 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 -
Using DTEXECUI to generate a DTEXEC command line statement the easy way
6July 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 -
Copying Connection Managers in SSIS
Leave a commentDecember 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 -
Looping through multiple servers in SSIS Part 3
16November 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 -
Looping through multiple servers in SSIS part 2
Leave a commentNovember 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 -
A review of Knight’s 24-Hour Trainer Microsoft SQL Server 2008 Integration Services
1November 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 -
Looping through multiple servers in SSIS
9October 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
