When I open the SSIS project from I can see the following error from the “Error List” Panel
‘Error 1 Validation error. Export Data Flow Task1: Package1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: “Microsoft OLE DB Provider for SQL Server” Hresult: 0x80004005 Description: “[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.”. Package1.dtsx 0 0 ‘
I am wondering why SQL Server access denied, at the end, I realise the SQL service do not start automatically.
TO solve it I just need to
“Start” -> “Control Panel“-> “Administrative Tools“-> “Services“
Then select the SQL Server instance that you want to start up the service.
Right click on it and select “Start“.
Then you may want to close down the project and re-open it again.
The error message should disappear.