Post reply

Can Package Migration Wizard migrate more than 1 dts packages at one time ?

  • January 8, 2009 at 11:09 pm

    #129042

    Hi ,

    i want to know if Package Migration Wizard can migrate more than 1 dts packages at one time , if the specified source is Structured storage files ?

    if yes , please explain how it can be done ?

    thanks in advance .

    Regards ,

    Nilay.

  • January 23, 2009 at 3:20 am

    #931707

    hi all,

    i am posting this reply to help those who also struggled with this issue i faced, and for those who might struggle and visit this forum for reply.

    The answer to the question is :-

    No . the wizard can not do this .

    But there are 2 workarounds :-

    1 > The migration wizard can only migrate more than one number of packages at a time, when it is fed a package which is a collection of packages to be executed i.e . this package contains the related packages clubbed together to be executed as a whole.

    2 > You can write a utility to which executes the migration wizard no of times you want it to.:)

  • January 23, 2009 at 9:10 am

    #931858

    Brian Knight also has a product that is advertised to migrate all packages in an instance. http://www.pragmaticworks.com/dtsxchange.htm

    I haven't tried it, but I've read the specs and may try the free trial version.

    Greg

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

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