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.".
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
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.
