I was trying to migrate some ‘big’ data to Azure today.
Well, not that big – about 20,000 rows.
But no matter how many times I tried, I was getting the following error:
Error: 0xC020844B at Table1, ADO NET Destination : An exception has occurred during data insertion, the message returned from the provider is: A transport-level error
Continue reading […] Migrating data to Azure: Error: 0xC020844B An existing connection was forcibly closed by the remote host […]
In my earlier blog post I wrote about setting up the WikiDB database and importing the files.
Initially I was inclined to import the XML files as they came – the files had different sizes ranging from 140 Mb to 7 Gb.
I managed to import the first 12 files, and thought I would stop there.
Continue reading […] Azure vs. inhouse SQL Server – the Wiki project – performance tuning […]
I have a SSIS package which was failing to execute from a SQL Server Agent job with the following error:
Unable to start execution of step 1 (reason: JobOwner EUR\s2sqlhotelldb01 doesn’t have permissions to use proxy 8 for subsystem SSIS). The step failed.
I solved the problem by changing the owner of the job to the account
Continue reading […] Proxy permissions in a sql server agent job […]