OLEDB connection error RRS feed

  • Question

  • Hi,

    I am really new to SQLserver so please excuse me if I miss or misstate any technical point.

    I am trying to populate tables by reading all files from a folder. I am using SSIS where I have a for each loop container and inside I have a data flow task. I have a flat file source connected to a OLE DB destination by a flat file connection. The OLE DB destination has a connection to antoher flat file destination using flat file manager from the error  output.

    When I execute I have multiple problems:



    Package Validation Error (Package Validation Error)




    Error at Data Flow Task [OLE DB Destination [9]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "WIN-JDSKU4ECB2K.VSS_Provider_TEST" 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 Destination" (9) 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 Package [Connection manager "WIN-JDSKU4ECB2K.VSS_Provider_TEST"]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.

    An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80004005  Description: "Login failed for user 'WIN-JDSKU4ECB2K\Administrator'.".

    An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80004005  Description: "Cannot open database "VSS_Provider_TEST" requested by the login. The login failed.".





    Program Location:


       at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.ValidateAndRunDebugger(Int32 flags, DataWarehouseProjectManager manager, IOutputWindow outputWindow, DataTransformationsProjectConfigurationOptions options)

       at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchDtsPackage(Int32 launchOptions, ProjectItem startupProjItem, DataTransformationsProjectConfigurationOptions options)

       at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchActivePackage(Int32 launchOptions)

       at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchDtsPackage(Int32 launchOptions, DataTransformationsProjectConfigurationOptions options)

       at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.Launch(Int32 launchOptions, DataTransformationsProjectConfigurationOptions options)

     Searching the web, I guess I might have the following problem:

    1. I am connecting to my server using windows login, but somehow it's not being able to see the password in runtime.

    2. My SQL server is 32 bit but I am running a 64 bit computer.

    The second issue I attempted to solve by setting Run 64bit runtime in the dtsx project properties as suggested in the msdn site. But it didn't solve the issue. First problem I am not so sure about how to approach the solutions suggested in this site or elsewhere. Can anyone guide through the solution a bit?

    Any other possible sources of the error would be welcome to be pointed out. And if possible elaborate a bit on how to proceed.


    Thanks in advance and sorry for making it long. 

    Friday, January 6, 2012 8:28 PM