October 16, 2014 at 1:07 am
[Reset connections] Error: Unable to log in to the server. 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.".
October 16, 2014 at 1:22 am
The error message seems quite clear: either you specified an incorrect connection string, or you (or the account executing the package) don't have the permissions.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 16, 2014 at 1:26 am
This Error Comming in Execeuting Script task. i have all permission and also bulding packages in local.
October 16, 2014 at 1:35 am
anbu899 (10/16/2014)
i have all permission...
The error says otherwise...
Can you share the code?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 17, 2014 at 4:09 am
Check the DB connection in the Connection Manager.. There's an option "Test Connection"..
If that works you should not be seeing this error.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply