Post reply

Multiple DTS pkg migrations

  • August 11, 2008 at 10:40 am

    #189190

    Oy! It's finally time. We're getting off our last 2000 server and need to migrate a whole bunch of packages from DTS to SSIS. But... Every technique I try to upgrade the packages with only allows me to upgrade one at a time.

    Isn't there a way where I can mass select a bunch of packages, say "Upgrade to .dtsx at Y location and log at Z location" and then worry about going into the packages individually to fix any problems?

    It's getting really annoying have to repeat the upgrade steps for this many packages. @=/

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • August 12, 2008 at 4:48 am

    #856572

    Ahha. I just figured it out. You can't do multiple dts packages when they're stored as Structured Storage Files. You can only do it when they're stored in the MSDB and you directly connect to the server.

    That stinks a bit. You'd think Microsoft would allow you to pick multiple SSFs also.

    Bleargh.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply