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

    avatar image

    alison
    3 1 1 2

    (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

    avatar image

    Fatherjack ♦♦
    43.7k 79 98 117

    (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.

    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:

    x2018
    x1146
    x86
    x71
    x56

    asked: Feb 08, 2010 at 10:49 AM

    Seen: 16328 times

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

    Copyright 2016 Redgate Software. Privacy Policy