November 30, 2007 at 7:56 pm
I have recently migrated from SQL2k to SQL2k5 and I now have many "legacy" DTS packages. This may just be the best opportunity I will have to rebuild these pkgs in the new SSIS tool. I know there is a migration wizard but how will I learn anything. Any suggestions for some great SSIS reading material I can cozy up to? I enjoy a good read...
November 30, 2007 at 9:05 pm
Brian Knight et al., "Professional SQL Server 2005 Integration Services"
December 1, 2007 at 1:12 am
Paul Turley, Joe Kasprzak, Scott Cameron (and others), Microsoft SQL Server 2005 Integration Services Step by step.
December 1, 2007 at 11:47 am
Either book is fine. I'm partial to Brian's book, but he's a business partner of mine, so I tend to use his resources.
I'd also look at sqlis.com
December 3, 2007 at 2:36 pm
"Microsoft SQL Server 2005 Integration Services" by Kirk Haselden.
Kirk is the Development Manager of Integration Services so I would believe that he know anything worth knowing about SSIS. It's an excellent book!
December 4, 2007 at 6:04 am
I have "Microsoft SQL Server 2005 Integration Services Step by step" and "Microsoft SQL Server 2005 Integration Services" and find both very helpful. Their examples offer slightly different perspectives. We have over 100 DTS packages that baffle the migration wizard due to our extensive use of ActiveX tasks.
December 4, 2007 at 4:40 pm
Microsoft SQL Server 2005
Integration Services
by Kirk Haselden
I would definitely give this one a look at.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply