x

DTS wizard error 80040154 for SQL Server 2005 Express

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

more ▼

asked Feb 08, 2010 at 10:49 AM in Default

alison gravatar image

alison
3 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

the answer may be here: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/2ea031b0-b79f-4b1f-9f2a-d5f980f5b1b0 - a dll to unregister...

" ...but you may try to register SQLTaskConnections.dll using RegSvr32..."

Or there is a suggestion here http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic24315.aspx that the error relates to SQL Agent not running. Are you running the package as a job or manually?

more ▼

answered Feb 08, 2010 at 06:19 PM

Fatherjack gravatar image

Fatherjack ♦♦
42.7k 75 79 108

thanks - registering the dll did the trick - wow - wish that i had asked significantly earlier!
Feb 10, 2010 at 12:21 PM alison
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1950
x939
x75
x66
x53

asked: Feb 08, 2010 at 10:49 AM

Seen: 7786 times

Last Updated: Feb 08, 2010 at 12:08 PM