i'm using the dts wizard that is provided via the additional tools for sql server 2005 express. i can connect to my server, select a db and select the table/view that i would like to export. likewise i can configure the target for the export to access, another sql server db, or xl. however - upon executing i get the following in the report when it fails.
Operation stopped...
- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Success)
- Setting Destination Connection (Success)
- Validating (Success)
- Prepare for Execute (Stopped)
- Pre-execute (Stopped)
- Executing (Error)
Messages
Error 0xc002f210: Preparation SQL Task: Executing the query "" failed with the
following error: "Retrieving the COM class factory for component with
CLSID {7816B7A3-CD60-4539-BD38-C35AFC61F200} failed due to the following
error: 80040154.". Possible failure reasons: Problems with the query, "ResultSet"
property not set correctly, parameters not set correctly, or connection not
established correctly.
(SQL Server Import and Export Wizard)
- Copying to `dt_location` (Stopped)
- Post-execute (Stopped)
- Cleanup (Stopped)
i have tried both sql native and oledb for sql server. when using ole i can export a table/view to txt. this is an ok soln but i really need to be able to use the dts for exporting multiple tables to an access db periodically.
i've spent a good amt of time reading every post that i can find relating to this topic and error number.
any help is greatly appreciated!!!
thanks, alison
