Category Archives: SSIS
-
What SQL version is my SSIS package?
28April 27, 2015 by Kenneth Fisher
When SSIS first came out there were huge numbers of jokes and posts about all of the problems and how …
Continue reading -
Finding active DTS packages
9November 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
8July 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
29November 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
3November 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
15October 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
SQL Studies 