Posts

Showing posts from 2018

Insert bulk statement does not support recompile (SQL 2017)

This happened to me once, source and target databases was located on the same server running 14.0.1000.169 Microsoft SQL Server Enterprise (64-bit) Consecutive executions never fail. I could not reproduce the error until next day. My workaround has been to simply add "re-try execution" a number of times in SQL Agent job. 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 11.0" Hresult: 0x80004005  Description: "Insert bulk statement does not support recompile.".  End Error

Workaround: Azure data factory GUI (v1 and v2) does not load

Image
When loading azure data factory, either via "Load Data" from your DW database, or via "Monitor and Manage" links. It never loads or show an empty page. In Edge it Loads forever, Showing splash screen In Chrome, it just shows an empty page (accesstoken.htm) The solution is that Microsoft requires third party cookies to be enabled in your client browser. This is bad, but as a workaround for Chrome: go to chrome://settings/content/cookies And add the follwoing domains to Allow section azure.com microsoftonline.com login.microsoftonline.com azureedge.net