Post reply

SSIS Master Package job fail in SQL Agent JOB

  • October 29, 2007 at 7:24 am

    #119147

    Hi

    I have created a SSIS master package. It is contains two child package. The master package is running in fine .

    But i am calling the master package in the sql server agent\jobs,the following error coming.

    An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available.

    Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D

    Description: "Login failed for user 'test1'."

    pl help me.

  • October 29, 2007 at 11:17 am

    #746336

    There's an issue w/ Child packages.

    When you deploy an SSIS package to a new server in SQL Server 2005 Service Pack 1, you receive an error message that resembles the following: The package is attempting to configure from the XML file " \Childxml.dtsConfig"

    Please review this link to see if you're affected: http://support.microsoft.com/kb/920882#appliesto

    BT

Viewing 2 posts - 1 through 2 (of 2 total)

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