Error while running SSIS Package (0x80040E4D)

  • Hi Karthik,

    Please try below points.

    1.If you are storing SQL connection string in database table.

    In case of SQL authentication please check the ConfiguredValue(Password and all are correct).

    2.Encrypt the package with "EncryptSensitiveWithPassword" or "EncryptAllWithPassword" and provide a package password each time User wants to edit/manipulate the package.

    --rhythmk
    ------------------------------------------------------------------
    To post your question use below link

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    🙂

  • ard5karthick (6/23/2012)


    Hi Koen,

    We are using Package Configuration to store the details in the Configuration table...

    Thanks,

    Karthick.

    That doesn't answer my question.

    You have a connection manager pointing to the SQL Server database where the configuration table is stored. How is this connection manager configured?

    Environment variable, XML config file, hard-coded,... ?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Hi bhuvneshk,

    I have tried those methods already but still i am getting the error...

  • Hi Koen,

    The Configuration Table is Placed in MSDB system database.

    As far as Configuration goes we are giving the server details and other required information and saving the data in the Table using Package Configuration into the Configuration Table...

  • Can you please tell me what are the properties you are saving in the table and if possible please provide the dummy values as well.

    --rhythmk
    ------------------------------------------------------------------
    To post your question use below link

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    🙂

  • Hi rhythmk,

    I have listed the properties i am storing below.

    FILE Path(File name):C:\Users\testuser\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.IE5\OEZNMMLB\FlatFile.data

    Server Name: 10.58.56.964

    User Name:TestUser

    Password:********

    Initial Catalogue:Data Source=10.58.56.964;User ID=TestUser;Initial Catalog=msdb;Provider=SQLNCLI10.1;Persist Security Info=True;Auto Translate=False;Application Name=SSIS-dtsTrailerPoolLoad-{E108C483-DA03-486D-BD30-697C8548FB7E}10.48.253.28.msdb.TestUser;

    Database Name:TrailTest

Viewing 6 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply