Post reply

Transferring sql 2000 jobs to sql 2005

  • December 29, 2009 at 8:23 am

    #141392

    We are migrating from one sql 2000 instance to and already existing sql 2005 instance. I have already moved the databases, DTS packages and Operators.

    I have about 30+ jobs that need to be transferred. When I select all jobs and generate a script on my 2000 instance, it only scripts the first job in the list even though all jobs are selected.

    I would really like to be able to create a script that would cover all jobs vs. a one by one scenario.

    Any thoughts or ideas???

  • December 29, 2009 at 8:32 am

    #1097053

    SSIS has a control flow task called "Transfer Jobs Task" it should help you achieve what you need.

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • December 29, 2009 at 8:54 am

    #1097064

    thanks for the reply.

    One caveat though....SSIS isn't installed, nor can we install it without a big corporate uprising (due to policies and procedures).

    Any other ideas.

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

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