locked
creating Sql server Configurations moving Packages from One location to another location ,setup an environment variable that holds the database connection string to the package configuration database on the machines where your SSIS package will run. RRS feed

  • Question

  • I am creating Sql server Configurations,while moving Packages from One location to another location ,setup an environment variable that holds the database connection string to the package configuration database on the machine(s) where your SSIS package will run.

    while running the package getting this error

    TITLE: Package Validation Error

    ------------------------------


    Package Validation Error


    ------------------------------
    ADDITIONAL INFORMATION:


    Error at Data Flow Task [OLE DB Source [57]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "(local).mrktng.sa" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.


    Error at Data Flow Task [SSIS.Pipeline]: component "OLE DB Source" (57) failed validation and returned error code 0xC020801C.


    Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.


    Error at Data Flow Task: There were errors during task validation.


    Error at Conditional [Connection manager "(local).mrktng.sa"]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E4D.
    An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80040E4D  Description: "Login failed for user 'sa'.".


     (Microsoft.DataTransformationServices.VsIntegration)

    can you please clarify me......


     


    OK


    • Edited by SrinivasMullamuri Wednesday, February 8, 2012 4:56 AM
    • Changed type Naomi N Wednesday, February 8, 2012 4:57 AM Question rather than discussion
    • Moved by Naomi N Wednesday, February 8, 2012 4:58 AM SSIS question (From:Transact-SQL)
    Wednesday, February 8, 2012 4:53 AM

Answers