Solving the SSIS error: The PrimeOutput method on component "…" (107) returned error code 0x80131502.

I was getting the errors:

 

Error 1

SSIS Error Code DTS_E_THREADFAILED.

Thread "SourceThread0" has exited with error code 0xC0047038.

There may be error messages posted before this with more information on why the thread has exited.

 

Error 2

SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.

The PrimeOutput method on component "SCR Read fout" (107) returned error code 0x80131502.

The component returned a failure code when the pipeline engine called PrimeOutput().

The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.

There may be error messages posted before this with more information about the failure.

 

Cause

This was caused by a SSIS script component, that had a vb substring error in it.

 

Solution

Fixing the substring exception fixed my problem.

Connecting Microsoft Outlook 2010 to hotmail

To read mine Hotmail e-mails in Microsoft Outlook 2010, I followed the steps at http://win.downloadatoz.com/tutorial/5480,how-to-connect-hotmail-and-live-email-accounts-with-outlook-2010.html.

with some adjustments:

 

If you follow the steps above and you don’t have the Microsoft Outlook 2010 Hotmail connector installed, you will be asked to download and install the connector.

– Install the 32 or 64 bit version

– Restart Microsoft Outlook 2010

– You will be asked if you want to add a new Hotmail account, enter the correct Hotmail account information

 

After entering the correct information I received the following "Send and Receive errors":

 

Task ‘test@msn.com’ reported error (0x8DE00005) : ‘This account does not have permission to synchronize your mail. To sign up to gain permission to synchronize with this account, please go to http://ideas.live.com and join the notification list for this Windows Live Hotmail product. You will be notified when your account is enabled.  Error: 3202. Server. HTTPS is turned on for the web but not for this program. ‘

 

Following the steps at: http://answers.microsoft.com/en-us/office/forum/office_2010-outlook/cannot-sendreceive-error-codes-0x80041059/eaec5d70-137e-41e5-9644-ea94dd9f1465 fixed the errors.

 

  • Sign in to Hotmail
  • Go to Options > More Options…

 

image

 

Click on "Account details (password, aliases, time zone)"

 

image

 

In the account overview go to: "Connect with HTTPS"

 

image

 

Check "Don’t use HTTPS automatically"

 

image

Soloving the error "The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered" in Microsoft SQL Server 2008 R2

When you don’t have Microsoft Office 2007 installed on a machine running Microsoft SQL Server 2008 R2 Integration Services, you might get the error "The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered"

 

Solution

To fix this problem:

Download and install the ACE provider from the following link, this supports office 2007 files both xls and xlsx file.
http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

 

 

Error

TITLE: Microsoft Visual Studio
——————————

Error at Org_eenheden [Connection manager "Excel Connection Manager"]: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR.  The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. Error code: 0x00000000.
An OLE DB record is available.  Source: "Microsoft OLE DB Service Components"  Hresult: 0x80040154  Description: "Class not registered".

Error at Load data into SA [Organisatie eenheden [1]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0209302.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.

 

——————————
ADDITIONAL INFORMATION:

Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap)

——————————
BUTTONS:

OK
——————————

Screendump

image

Using Common Table Expressions to query a SQL Server table containing hierarchical data (e.g. a parent having children)

If you have a table containing hierarchical data (e.g. a parent having children) and you want to show all the children and grand children for a person you can use a "Common Table Expression" in Microsoft SQL Server 2008.

 

Table Person

image

 

Table Person Data

truncate table person
insert into person (Id, Name, Birthday, ParentId) values (1, 'John Do', '1950-6-1', null)
insert into person (Id, Name, Birthday, ParentId) values (2, 'Carl Do', '1980-3-5', 1)
insert into person (Id, Name, Birthday, ParentId) values (3, 'Michael Do', '2010-12-12', 2)
insert into person (Id, Name, Birthday, ParentId) values (4, 'Tonny Jackson', '1915-3-3', null)
insert into person (Id, Name, Birthday, ParentId) values (5, 'Bo Jackson', '1945-7-7', 4)
insert into person (Id, Name, Birthday, ParentId) values (6, 'Harry Jackson', '1981-4-4', 5)
insert into person (Id, Name, Birthday, ParentId) values (7, 'Bart Jackson', '2009-12-11', 6)

image

 

 

Returning a person with all it’s children and grandchildren

declare @PersonId int
set @PersonId = 4
-- Define the "Common Table Expression" with name "person_cte"
; with person_cte as (
-- Select all the direct children of the given person
select        p2.Id,
p2.Name,
p2.Birthday,
p2.ParentId
from        person p1
inner join person p2 on p2.ParentId = p1.Id
where        p1.Id = @PersonId 
union all
-- Add grandchildren's, by recursively calling this "Common Table Expression"
select        p1.Id,
p1.Name,
p1.Birthday,
p1.ParentId
from        person_cte p2
inner join person p1 on p1.ParentId = p2.Id
) 
select
Id,
Name,
Birthday,
ParentId
from person_cte
union all
-- Add the given person to the result
select
Id,
Name,
Birthday,
ParentId
from person
where Id = @PersonId
order by Birthday

Result

image

 

Background information:

Using Common Table Expressions: http://msdn.microsoft.com/en-us/library/ms190766.aspx

Recursive Queries Using Common Table Expressions: http://msdn.microsoft.com/en-us/library/ms186243.aspx

Solving Unable to generate a temporary class error CS2001 en CS2008

 

Error

 

System.InvalidOperationException: Unable to generate a temporary class (result=1).
error CS2001: Source file 'C:\Windows\TEMP\beo4ycyh.0.cs' could not be found
error CS2008: No inputs specified
at System.Xml.Serialization.Compiler.Compile(Assembly parent, String ns, XmlSerializerCompilerParameters xmlParameters, Evidence evidence)
at System.Xml.Serialization.TempAssembly.GenerateAssembly(XmlMapping[] xmlMappings, Type[] types, String defaultNamespace, Evidence evidence, XmlSerializerCompilerParameters parameters, Assembly assembly, Hashtable assemblies)
at System.Xml.Serialization.TempAssembly..ctor(XmlMapping[] xmlMappings, Type[] types, String defaultNamespace, String location, Evidence evidence)
at System.Xml.Serialization.XmlSerializer.FromMappings(XmlMapping[] mappings, Type type)
at System.Web.Services.Protocols.XmlReturn.GetInitializers(LogicalMethodInfo[] methodInfos)
at System.Web.Services.Protocols.HttpServerType..ctor(Type type)
at System.Web.Services.Protocols.HttpServerProtocol.Initialize()
at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing)

 

Solution

After adding the application pool service account to the local administrators group, this error was resolved.

We are now looking into a real solution Winking smile

Solving: Could not load file or assembly ‘App_Web_squ1ikqu, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null’ or one of its dependencies. The system cannot find the file specified in .NET 4.0

After we virtualized a production machine and booted this virtualized machine, .NET reported some errors after re-registering .NET 4.0 on IIS7 these error where resolved, but one WCF service kept on logging the error:

Could not load file or assembly ‘App_Web_squ1ikqu, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null’ or one of its dependencies. The system cannot find the file specified.

 

Solution

The error was resolved after stopping all application pools in IIS7 and deleting the temporary internet files in the following folders:

  • C:\Windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files
  • C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files
  • C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Temporary ASP.NET Files
  • C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files