Post reply

Migration DTS and job

  • December 12, 2007 at 1:41 am

    #181239

    Hi,

    I had done my migration from SQL2000 to SQL2005. I have one db for 2gig and the other one for 1Gig

    Version of SQL2005: 9.0.1399

    I made restore form a backup for data => result OK

    But when I want import my DTS from SQL2000 to my server SQL2005, I have this error:

    "index was out of range. Must be non-negative and less than the size of the collection.

    Parameter name: index (mscorlib)"

    I found this solution in the forum: rename DTS on SQL2000 without blank in the name and redo the importation

    Result => same error !!!

    Someone have a better idea?

    If I will pass the SP2 on my SQL2005, I will fix my error?

    And how I can import all my jobs (in SQL2000 [management, sql server agent, jobs]) to my SQL2005?

    thanks

    Jean-François Lefebvre

    jf_lefebvre@hotmail.com

  • December 12, 2007 at 2:09 am

    #759299

    For information:

    I have SP2 on my SQL 2000

    maybe update to SP4 to fix my error?

    thanks

    JFL

  • December 12, 2007 at 10:02 am

    #759497

    I've had the best luck saving DTS packages as .dts files then opening them in SQL 2005 SQL Server Management Studio and resaving them as legacy packages.

    As for jobs, script them out in Enterprise Manager, then run the script in the SQL 2005 instance.

    Greg

    Greg

  • December 13, 2007 at 1:52 am

    #759718

    I'd second that approach, I did the same and it all went well. OK it was a pain with over a hundred packages but we got the best results this way and we kep the formatting when we imported them into 2005.

    Howard

  • December 13, 2007 at 7:17 am

    #759817

    Hi,

    Thanks for yours answers.

    I did that:

    - for DTS, save in file.dts and with importation dts, I had saved them in in sql2005

    - for jobs in sql2000, I had saved them in a file.sql and run the script in sql2005

    everything was ok

    thanks

    JF

Viewing 5 posts - 1 through 4 (of 4 total)

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