locked
sql server 2000 Migration RRS feed

  • Question

  • I am working on a project where they want to do a migration to a new VM/OS. Problem is they have lost the passwords for sql server logins. My first thought is to do an upgrade instead. The following is from the DTS migration wizard. ANy thoughts would be greatly appreciated. Thanks.

    Migrating the packages...

    - -Member Finder Setup DOTW PHX_CL_01--->SBA-SQL-10 (Stopped)
        Messages
        * Object name "-Member Finder Setup DOTW PHX_CL_01--->SBA-SQL-10" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({946AAA2A-3B40-41F5-B65F-BB4AF54D5D7D})
        
        ------------------------------
        ADDITIONAL INFORMATION:
        
        Object name "-Member Finder Setup DOTW PHX_CL_01--->SBA-SQL-10" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({946AAA2A-3B40-41F5-B65F-BB4AF54D5D7D})
        

    - -Member Finder Setup DOTW PHX_CL_01--->SBA-SQL-10.stg (Stopped)
        Messages
        * Object name "-Member Finder Setup DOTW PHX_CL_01--->SBA-SQL-10 stg" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({85130876-83EC-4120-B96E-ADAB21C4182C})
        
        ------------------------------
        ADDITIONAL INFORMATION:
        
        Object name "-Member Finder Setup DOTW PHX_CL_01--->SBA-SQL-10 stg" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({85130876-83EC-4120-B96E-ADAB21C4182C})
        

    - -Member Finder Setup DOTW SBA-MEMBER-DEV--->SBA-SQL-10.dev (Stopped)
        Messages
        * Object name "-Member Finder Setup DOTW SBA-MEMBER-DEV--->SBA-SQL-10 dev" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({EB28C869-5C19-462D-A02C-6925B13B6DB7})
        
        ------------------------------
        ADDITIONAL INFORMATION:
        
        Object name "-Member Finder Setup DOTW SBA-MEMBER-DEV--->SBA-SQL-10 dev" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({EB28C869-5C19-462D-A02C-6925B13B6DB7})
        

    - -Member Finder Setup Misc PHX_CL_01--->SBA-SQL-10 (Stopped)
        Messages
        * Object name "-Member Finder Setup Misc PHX_CL_01--->SBA-SQL-10" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({14F00425-EEEB-4CF4-8743-B85DFC92BBE8})
        
        ------------------------------
        ADDITIONAL INFORMATION:
        
        Object name "-Member Finder Setup Misc PHX_CL_01--->SBA-SQL-10" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({14F00425-EEEB-4CF4-8743-B85DFC92BBE8})
        

    - -Member Finder Setup Misc PHX_CL_01--->SBA-SQL-10.stg (Stopped)
        Messages
        * Object name "-Member Finder Setup Misc PHX_CL_01--->SBA-SQL-10 stg" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({E9845707-11E3-400B-B934-6F8686293C7E})
        
        ------------------------------
        ADDITIONAL INFORMATION:
        
        Object name "-Member Finder Setup Misc PHX_CL_01--->SBA-SQL-10 stg" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({E9845707-11E3-400B-B934-6F8686293C7E})
        

    - -Member Finder Setup Misc SBA-MEMBER-DEV--->SBA-SQL-10.dev (Stopped)
        Messages
        * Object name "-Member Finder Setup Misc SBA-MEMBER-DEV--->SBA-SQL-10 dev" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({47C7AAB1-CC36-41FA-8115-53A05ECE3F5F})
        
        ------------------------------
        ADDITIONAL INFORMATION:
        
        Object name "-Member Finder Setup Misc SBA-MEMBER-DEV--->SBA-SQL-10 dev" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({47C7AAB1-CC36-41FA-8115-53A05ECE3F5F})
        

    - MEMBERSHIP_DB --> CAMPAIGN.AZBAR.ORG (Stopped)
        Messages
        * Object name "MEMBERSHIP_DB --> CAMPAIGN AZBAR ORG" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({F502738D-BFDC-43EA-80C6-A8992CB135D0})
        
        ------------------------------
        ADDITIONAL INFORMATION:
        
        Object name "MEMBERSHIP_DB --> CAMPAIGN AZBAR ORG" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({F502738D-BFDC-43EA-80C6-A8992CB135D0})
        

    - -MiniApps Setup Misc SBA-MEMBER-DEV--->SBA-SQL-10.dev (Stopped)
        Messages
        * Object name "-MiniApps Setup Misc SBA-MEMBER-DEV--->SBA-SQL-10 dev" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({044AC0E1-81F3-4CE5-8F71-B6A99E4DC6AE})
        
        ------------------------------
        ADDITIONAL INFORMATION:
        
        Object name "-MiniApps Setup Misc SBA-MEMBER-DEV--->SBA-SQL-10 dev" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({044AC0E1-81F3-4CE5-8F71-B6A99E4DC6AE})
        

    - -MiniApps Setup Misc WEBSQL--->SBA-SQL-10 (Stopped)
        Messages
        * Object name "-MiniApps Setup Misc WEBSQL--->SBA-SQL-10" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({AB22338C-9D15-4A9E-AD6D-13DCCEDE6B7B})
        
        ------------------------------
        ADDITIONAL INFORMATION:
        
        Object name "-MiniApps Setup Misc WEBSQL--->SBA-SQL-10" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({AB22338C-9D15-4A9E-AD6D-13DCCEDE6B7B})
        

    - -MiniApps Setup Misc WEBSQL--->SBA-SQL-10.dev (Stopped)
        Messages
        * Object name "-MiniApps Setup Misc WEBSQL--->SBA-SQL-10 dev" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({43CD1FDB-4F8A-4CB0-88E8-73AE357C913D})
        
        ------------------------------
        ADDITIONAL INFORMATION:
        
        Object name "-MiniApps Setup Misc WEBSQL--->SBA-SQL-10 dev" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({43CD1FDB-4F8A-4CB0-88E8-73AE357C913D})
        

    - -MiniApps Setup Misc WEBSQL--->SBA-SQL-10.stg (Stopped)
        Messages
        * Object name "-MiniApps Setup Misc WEBSQL--->SBA-SQL-10 stg" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({9FE7FF2D-BC8A-4E43-B1E3-9467F3D4F417})
        
        ------------------------------
        ADDITIONAL INFORMATION:
        
        Object name "-MiniApps Setup Misc WEBSQL--->SBA-SQL-10 stg" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({9FE7FF2D-BC8A-4E43-B1E3-9467F3D4F417})
        

    - Nightly Online Dues - PHX_CL_01 <------- > PROD (Stopped)
        Messages
        * Object name "Nightly Online Dues - PHX_CL_01 <------- > PROD" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({B9BAE29B-C3C6-4C54-B288-4DA3712EA785})
        
        ------------------------------
        ADDITIONAL INFORMATION:
        
        Object name "Nightly Online Dues - PHX_CL_01 <------- > PROD" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({B9BAE29B-C3C6-4C54-B288-4DA3712EA785})
        

    - Nightly Online Dues - SBA-MEMBER-DEV <------- > STAGING (Stopped)
        Messages
        * Object name "Nightly Online Dues - SBA-MEMBER-DEV <------- > STAGING" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({19F0A616-DB42-4ACF-91BE-374B37C0AC8A})
        
        ------------------------------
        ADDITIONAL INFORMATION:
        
        Object name "Nightly Online Dues - SBA-MEMBER-DEV <------- > STAGING" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({19F0A616-DB42-4ACF-91BE-374B37C0AC8A})
        

    - Online Address Change (Success)

    - Online_Convention_Registration (Success)

    - Online_Convention_Registration_WEBSQL.STG----->SBAMEMBER-DEV (Stopped)
        Messages
        * Object name "Online_Convention_Registration_WEBSQL STG----->SBAMEMBER-DEV" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({73738A42-F1FF-4C8E-AA76-3CD5D6716983})
        
        ------------------------------
        ADDITIONAL INFORMATION:
        
        Object name "Online_Convention_Registration_WEBSQL STG----->SBAMEMBER-DEV" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({73738A42-F1FF-4C8E-AA76-3CD5D6716983})
        

    - Online_Convention_Registration_WEBSQL.STG----->STAGEHUB (Stopped)
        Messages
        * Object name "Online_Convention_Registration_WEBSQL STG----->STAGEHUB" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({1CE47972-A3EF-43FF-9A9B-0C8D03D8C4A0})
        
        ------------------------------
        ADDITIONAL INFORMATION:
        
        Object name "Online_Convention_Registration_WEBSQL STG----->STAGEHUB" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({1CE47972-A3EF-43FF-9A9B-0C8D03D8C4A0})
        

    - Pull_DOTW_Info_Requests (Success)

    - Refresh Member_Bios (Success)

    - SBA-FINANCE-02 --> MEMBERSHIP_DB (Stopped)
        Messages
        * Object name "SBA-FINANCE-02 --> MEMBERSHIP_DB" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({1AE7F50A-A8E5-4C76-B0D4-82EF2358B6DD})
        
        ------------------------------
        ADDITIONAL INFORMATION:
        
        Object name "SBA-FINANCE-02 --> MEMBERSHIP_DB" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |
         ({1AE7F50A-A8E5-4C76-B0D4-82EF2358B6DD})
        

    - Weekly Campaign (Success)

    - WWW statebardb nightly update (Success)




    Alan

    Saturday, February 24, 2018 6:33 PM

All replies

  • Object name "-Member Finder Setup DOTW PHX_CL_01--->SBA-SQL-10 stg" is not valid. The name cannot contain any of the following characters: / \ : ? " < > |--->

    Books online has this to say about migrating DTS packages: "In some cases, such as when the package name contains invalid characters (/ \ : [ ] . =), or when the package contains unregistered objects, the Package Migration Wizard cannot perform the migration until these issues are resolved."


    https://social.technet.microsoft.com/wiki/contents/articles/37872.sql-server-installation-on-centos-linux.aspx

    Saturday, February 24, 2018 9:26 PM
  • Ok. It looks like special characters in the name of the packages was the problem. So can someone tell me what issues is changing the names going to make? What steps do I need to take? Thanks.

    Alan

    Sunday, February 25, 2018 1:32 AM
  • Hello Alan,

    SQL Server 2000 is out of support since a long time, and DTS packages/task aren't supported in newer SSIS versions as well.

    Instead of trying to fix them better recreate them as new SSIS packages.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Sunday, February 25, 2018 5:40 AM