Could not create DTS.Application because of error 0x800401F3

Hot Topic

Report Server (MSSQLSERVER) cannot connect to the report server database.
Setting DTS DataType on added column: codepage.
Incremental loading
sql server 2000
Email tasks fail after an unsuccessful SQL 2005 installation
how to make the contents of sqlserver tables, case sensitive?
Can't complete SQL Server 2005 installation!!!
CREATE Credential Secret Storage
Sort by month
Can't Edit Table

SQL Server

Dynamic chart generation
Bulk Load Failure
How to execute SSIS package inside of Visual Studio?
Using TRY...CATCH with RAISERROR
Migrating Legacy Maintenance Plans to SSIS?
file attribute using a control
Synchronization of Business Contacts in Outlook with Small Business Accounting
Notification Services & Triggers
I get "Line 1: Incorrect syntax near ')'." when using SqlClient ExecuteScalar
Specialized join of two tables

Could not create DTS.Application because of error 0x800401F3

I am trying to run an ssis package from a classic asp web page.

if I run it from the command line it works as expected.

dtexec /f D:\publish\mypackage.dtsx

however if I try to run it from the web page - I get the following error:

"Could not create DTS.Application because of error 0x800401F3"

I am assuming this is a permissions error - can anyone help

Can I run a dts package from classic asp



Answer this question

Could not create DTS.Application because of error 0x800401F3

  • Jason Walker

    Google the error code and it comes up with "Invalid Class string" or "invaldi ProgID" which means the COM component is not installed or registered. Check you have installed and registered the component correctly on the web server.

  • tobek

    Your security settings are wrong, so fix that for a start. The username looks very wrong. First why does it begin with two slashes, the format for Windows security usernames is usually domain\username, with any preceding slashes. More importantly however is the fact that you are being asked for SQL Server security credentials, but you appear to be supplying windows credentials, and this will never work. SQL Server credentials will never include a domain name, they are specific to that instance of SQL Server only. If you do not have SQL Server security credentials (for which you must enable mixed mode security), then you must use windows security, also known as trusted security as you do not and cannot supply usernames or passwords, it takes the credentials of the process making the call. For ASP this will be the IUSER/IWAM_machinename account. Have a look at this article and the related links (http://www.sqldts.com/default.aspx 207), they cover security from a ASP/DTS perspective, but nothing much as has change for that with SSIS.

  • sam_dlg

    Thank you - that is what I found -

    now I get this error when I try to execute the package.

    Could not load package "single" because of error 0xC0014062.
    Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80040E4D (Login failed for user '\\MPDNETWEB\Administrator'.). The SQL statement that was issued has failed

    I am trying to run this from a web page. (asp classic)

    I am passing the username and password , but its telling me its incorrect.

    in the event log I see this

    Login failed for user '\\MPDNETWEB\Administrator'. [CLIENT: <local machine>]

    Can someone help me I am desperate at this point .,

    What settings must I set to get this to work

    Thank you in advance
  • Could not create DTS.Application because of error 0x800401F3
Answer this question