Advice required, please.
I'm currently running dts jobs from an original 2000 SS implementation on a 2005 SS install by way of dtsrun in SS Agent. There are a good five dozen jobs that run daily/weekly.
I know that I should be converting these jobs to SSIS ones to allow for the eventual upgrade to 2008 (and then 2008 R2).
Could any of you recommend a book that will assist on doing such or an opinion on a suitable MS course? "Implementing and Maintaining Microsoft SQL Server 2008 Integration Services - 6235 Course" seems to be on point here. I undertook 2780B - "Maintaining a SQL Server 2005 Database" - a few years back and that has helped with other aspects.
Thanks in advance for all replies,
Lex
soi là, soi carré
I'm currently running dts jobs from an original 2000 SS implementation on a 2005 SS install by way of dtsrun in SS Agent. There are a good five dozen jobs that run daily/weekly.
I know that I should be converting these jobs to SSIS ones to allow for the eventual upgrade to 2008 (and then 2008 R2).
Could any of you recommend a book that will assist on doing such or an opinion on a suitable MS course? "Implementing and Maintaining Microsoft SQL Server 2008 Integration Services - 6235 Course" seems to be on point here. I undertook 2780B - "Maintaining a SQL Server 2005 Database" - a few years back and that has helped with other aspects.
Thanks in advance for all replies,
Lex
soi là, soi carré