MS SQL Server DTS - SQL Server 2005 Import and Export Wizard Error

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SQL Server 2005 Import and Export Wizard Error

Steve W

2006-01-26, 4:58 pm

I am getting the following error when trying to import data from a SQL Server
2000 database table to SQL Server 2005:

Operation stopped...

- Initializing Data Flow Task (Success)

- Initializing Connections (Success)

- Setting SQL Command (Success)

- Setting Source Connection (Error)
Messages
* The connection " SourceConnectionOLED
B" is not found. This error is thrown
by Connections collection when the specific connection element is not found.
({DF4E45CF-85AA-4E41-9491-D1EE0A16318F})

- Setting Destination Connection (Stopped)

- Validating (Stopped)

- Prepare for Execute (Stopped)

- Pre-execute (Stopped)

- Executing (Stopped)

- Copying to [ShadowDB].[dbo].& #91;DBA_SharePointDB
SizeHistory] (Stopped)

- Post-execute (Stopped)

- Cleanup (Stopped)

Sponsored Links