none
Trouble with DTS launch RRS feed

  • Question

  • Good afternoon.
    Created a DTS package.
    When it is executed, an incomprehensible user access error is issued

    Code

    DECLARE @returncode int
    EXEC @returncode = xp_cmdshell 'dtexec /f "D:\DTSPackges\Packages.dtsx"'

    Error

    Error: 2020-01-05 20:16:11.29
    Code: 0xC0202009
    Source: PackagesConnection manager "DestinationConnectionOLEDB"
    Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D.
    An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E4D Description: "User Login Error  "Domain\NOTIAM".".
    End Error

    I am trynig through JOB and it is writes

    Message
    Executed as user: DOMAINT\NOTIAM. 

    0xC0202009     Source: UCDAA Connection manager "DestinationConnectionOLEDB"     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E4D.  An OLE DB record is available.  Source: "Microsoft OLE DB Provider for SQL Server"  Hresult: 0x80040E4D  Description: "User Login Error  "DOMAINT\NOTIAM".".  End Error  Error: 2020-01-07 18:34:18.21     Code: 0xC020801C     Source: Data Flow Task 1 Destination - Cards_Discount_ActionTest [2]     Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.   

    In JOB in Owner it is User Domain\IAM

    How i can start under User Domain\IAM?


    Tuesday, January 7, 2020 3:48 PM

All replies

  • Hello Friend ,

    Verify that the user runs the Sql Server Agent or SSIS service.

    If this answer has helped you, mark it helpful so that someone else with a question or similar problem can find an answer or help more easily. Jefferson Clyton Pereira da Silva - [MCSA | MCP | MCTS | MTA | Database Analyst - Sql Server and Oracle]
    Wednesday, January 8, 2020 2:28 AM