it says Error: The AcquireConenction method call to connection manager "name of conn" failed with error code 0xC0014019 and
it says can't Aquire Connections because OfflineMode is true, while as I checked several times while saving the package it is set to false...
One of our developers had the same problem today... try this technet article. I think there are two places where you can set it. A config file and the project settings themselves.
http://technet.microsoft.com/en-us/library/ms137749.aspx
|||Error says OfflineMode is true, but actually it is not..|||
One of my collegues ran into the same issue some time ago. After contacting MSF support and several rounds of troubleshooting, I think he ended up re-installing SSIS and the problem went away...Sorry, but I don't have more details.
|||We encountered this issue some time ago. We incurred this error when trying to execute the 32bit DTEXEC (Program Files (x86)) on a 64bit machine.
As Rafael mentioned after contacting Microsoft support we simply reinstalled the client tools for SSIS and the problem was resolved. We were unable to identify the specific cause of the issue. I believe this is another very similar thread that was discussed a while back: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1557996&SiteID=1
|||I resolved the issue, I changed the connection settings and executed it using 64-bit dtexec from command promptsql
No comments:
Post a Comment