Import/Export Wizard in SQL 2005 version seems to not work.

• Michael Robey

  SSC Veteran

  Points: 285

  More actions

  December 13, 2005 at 7:15 am

  #166256

  We have installed SQL Server Standard Edition 2005 on 2 machines.  On both machines if we try to import or export from any version to any version we get the following error message:

  Operation stopped...

  - Initializing Data Flow Task (Success)

  - Initializing Connections (Success)

  - Setting SQL Command (Success)

  - Setting Source Connection (Error)

   Messages

   * The connection "SourceConnectionOLEDB" is not found. This error is thrown by Connections collection when the specific connection element is not found.

    ({E39E9D4C-ADEC-4265-A954-BCA2DEC4B542})

   

  - Setting Destination Connection (Stopped)

  - Validating (Stopped)

  - Prepare for Execute (Stopped)

  - Pre-execute (Stopped)

  - Executing (Stopped)

  - Copying to [IRM_MAINT].[dbo].[SQLSchemaLinks] (Stopped)

  - Post-execute (Stopped)

  - Cleanup (Stopped)

  Has any one seen this yet?

  Thanks,

   

   

   

• Joseph Mulhall

  SSCarpal Tunnel

  Points: 4672

  More actions

  December 15, 2005 at 3:34 am

  #609674

  As you can see the problem is in connecting to the source you are trying to import.

  Anaylaze all aspects of the connection, networking, permissions etc. and pst up what you find.

  Merry Christmas