Solving the SSIS 2005 Excel Connection Manager error 0x80040E09

I was getting a 0x80040E09 error, when exporting some rows to an Excel file in SSIS 2005. This was caused by the destination Excel file being read-only. After I cleared the read-only checkbox on the file, the error was resolved.

 

Error

Error: 0xC0202009 at Data Flow Task, Excel Destination [16]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E09.
Error: 0xC0047022 at Data Flow Task: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "Excel Destination" (16) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.  There may be error messages posted before this with more information about the failure.
Error: 0xC0047021 at Data Flow Task: SSIS Error Code DTS_E_THREADFAILED.  Thread "WorkThread0" has exited with error code 0xC0202009.  There may be error messages posted before this with more information on why the thread has exited.

Solving the SSIS 2005 Excel Connection Manager (Excel Destination) Error 0x80040E21

I was getting as 0x80040E21 error on a SSIS 2005 package when exporting some rows to an Excel file.

 

In my case this was caused by an input column of the type varchar(max) after converting this column in my t-sql query to a varchar(1024) column the error was resolved.

 

Error

Error: 0xC0202009 at Data Flow Task, Excel Destination [16]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E21.
Error: 0xC0202025 at Data Flow Task, Excel Destination [16]: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
Error: 0xC004701A at Data Flow Task, DTS.Pipeline: component "Excel Destination" (16) failed the pre-execute phase and returned error code 0xC0202025.

Adding date and time to a log file path in SSIS 2005

Right click your log file connection, click on properties

In the property windows click on Expressions > ConnectionString

image

 

Expression

Add the expression:

(DT_WSTR,1000)
(
  "C:\Temp\" +
  RIGHT("0" + (DT_STR,4,1252) DATEPART("year",GETDATE()),4) +
  RIGHT("0" + (DT_STR,2,1252) DATEPART("month",GETDATE()),2) +
  RIGHT("0" + (DT_STR,2,1252) DATEPART("day",GETDATE()),2) +
  RIGHT("0" + (DT_STR,2,1252) DATEPART("hour",GETDATE()),2) +
  RIGHT("0" + (DT_STR,2,1252) DATEPART("minute",GETDATE()),2) +
  RIGHT("0" + (DT_STR,2,1252) DATEPART("second",GETDATE()),2) +
  ".log"
)

 

Result

Result will be: C:\Temp\20101126121212.log

‘Sys’ is undefined or ASP.NET Ajax client-side framework failed to load in a ASP .NET 4.0 website

I was getting the the error [‘Sys’ is undefined] and [ASP.NET Ajax client-side framework failed to load] in an ASP .NET 4.0 website. After reading and following the post [http://weblogs.asp.net/chrisri/archive/2007/02/02/demystifying-sys-is-undefined.aspx] I found my solution.

De ScriptResource.axd [long url] was throwing a 404 server error. This was caused by the fact that the website had an application pool set to .NET 4.0 but the [Handler Mappings] (see Screen dump 001) for the *.axd files where not registered. Even after executing the [aspnet_regiis –i –enable] the [Handler Mappings] where not registered. After re-creating the site, the error was resolved. The screen dump 002 shows the correct handler mappings.

 

Screen dump 001

image

 

Screen dump 002

image

Using XBMC on mine ASROCK 330 Pro

 

Replacing the stock fans
First thing I did was updating the bios to the latest version and replacing the stock fans by more silent fans, because this reduced the sound level significantly. I used the  Noiseblocker BlackSilent XM2, 40mm and Noiseblocker BlackSilent XM1, 40mm. Used the XM1 to blow air out of the asrock 330 Pro and de XM2 to blow air over the cpu and gpu.

 

Create XBMC Live DVD
I downloaded the XBMC Live CD from the [http://xbmc.org/download/]. Right click the ISO and choose [Open with] > Windows Disc Image Burner and burn the ISO to a DVD. Start the Asrock 330 Pro and boot from the DVD.

 

Rember username and password
Remember the Username and Password you enter during setup. It will be needed when you want to access XBMC remotely with SFTP.

 

Setting up SFTP root access, step 1
– Download putty from: "http://www.putty.org/"
– Start Putty and type in the IP address of XBMC to connect.
– Username: As entered during installation of XBMC live
– Password: As entered during installation of XBMC live
– Enter the commando: sudo passwd root
This will prompt you to change the root password, use the same password as entered during installation of XBMC live.
– Close Putty.

 

Setting up SFTP root access, step 2

Start a free program like WinScp or FileZilla and connect to XBMC live:
Host: sftp://xxx.xxx.xxx.xxx (IP address can be found in XBMC live on the System > Network)
Port: 22
Username: root
Password: As entered during installation of XBMC live

You now have root access to XBMC Live and can see/edit any folder on the system.

image

 

XBMC Settings

Setting Value
System > Appearance > Skin Transparency!
System > Appearance > International > Region Central Europe
System > Appearance > File lists Allow file renaming and deletion
System > Appearance > Screensaver Use visualization if playing audio [Disable]
System > Input devices Remote control sends keyboard presses
System > Audio Ouput > Audio output Optical/Coax
System > Audio Ouput > Speaker Configuration 5.1
System > Audio Ouput > Audio output device iec958
Network > Services Share video and music libraries through UPnP
Network > Services Allow control of XBMC via UPnP
Network > Services Allow control of XBMC via HTTP
Network > Services Allow programs on other systems to control XBMC
Weather Breda

 

 

Enable SAMBA
If you want to access the internal hard disk of the asrock 330 pro, from you’re Windows pc, you can use SAMBA

Start putty and connect to XBMC live in my case: 192.168.1.19
Username: root
Password: As entered during installation of XBMC live

Enter commandos

apt-get update
To update sources

sudo apt-get install samba
This will install samba and start it running

nano /etc/samba/smb.conf
This will open the samba configuration for editing

Copy and paste the following lines at the end of the file
[xbmc home]
comment = XBMC Home Share
path = /home/xbmc
force user = xbmc
inherit permissions = yes
read only = No
guest ok = Yes

[xbmc system]
comment = XBMC System Share
path = /home/xbmc/.xbmc
force user = xbmc
inherit permissions = yes
read only = No
guest ok = Yes

Ctrl + x followed by Y to save the file
– After rebooting the XBMC live, you can access the two shares created in Windows explorer by just entering the IP address, like \\192168.1.19

More info
Most information I found at: [http://redherring2.wordpress.com/2009/06/11/xbmc-live-asrock-ion-330-setup-guide/]
– After applying the "Judder free video improvements" patch described on this blog post my mkv files played flowless.

Using an T-SQL update statement with a @COUTNER variable to provide consecutive numbers in a column

If you have a table in a Microsoft SQL Server database with an integer column that contains rows and you want to update the existing rows to  contain consecutive numbers, you can use the following T-SQL query:

declare @COUNTER as int
set @COUNTER = 0 -- First number will be [1] 
-- Update the [Number] column, so it contains consecutive numbers
update        [TestTable]
set            [Number] = @COUNTER, @COUNTER = @COUNTER + 1

How to import a Microsoft Word 2010 document in OneNote 2010

If you want to import a Microsoft Word 2010 document in OneNote you will have several options.

 

Insert a print out of the document
Just drag and drop your Microsoft Word 2010 document on your OneNote 2010 page and choose [Insert the file as printout so I can add notes to it]

image

 

In most cases I choose this option, because you can immediately the content of the document in the correct format and still be able to edit the document in it’s original format:

image

 

 

Insert a copy of the document

Just drag and drop your Microsoft Word 2010 document on your OneNote 2010 page and choose [Insert a copy of the file onto the page]

image

image

Insert a link to the document

Just drag and drop your Microsoft Word 2010 document on your OneNote 2010 page and choose [Insert a link to the original file]

image

 image

Copy and Paste
Just press CTRL + A in your Microsoft Word 2010 document en press CTRL + C then in your OneNote 2010 page, press CTRL + V.

Consequences
– It will change the chapter and paragraph numbering
– It will change the layout of your document

image

Adding a reference to an OData service in a C# .NET 4.0 class library

This post describes the steps I took to add a OData Service reference to a C# .NET 4.0 class library.

Description Screendump
Open you’re .NET 4.0 C# class library project in Microsoft Visual Studio 2010  
Right click you’re project in the solution explorer and choose 001
Enter you’re odata service address and click on GO 002
In my case I use basic authentication, so I have to enter my credentials (twice)  

 

 

Screendump 001

image

Screendump 002

image

 

[Unable to load the specified metadata resource.]
I was getting the error [Unable to load the specified metadata resource.].
This can mean many things, but in mine case it was the Entity Framework connection string.

Stacktrace
System.Data.Metadata.Edm.MetadataArtifactLoaderCompositeResource.LoadResources
System.Data.Metadata.Edm.MetadataArtifactLoaderCompositeResource..ctor                                  System.Data.Metadata.Edm.MetadataArtifactLoaderCompositeResource.CreateResourceLoader
System.Data.Metadata.Edm.MetadataCache.SplitPaths
System.Data.Common.Utils.Memoizer`2.Result.GetValue
System.Data.Common.Utils.Memoizer`2.Evaluate
System.Data.EntityClient.EntityConnection.GetMetadataWorkspace
System.Data.Objects.ObjectContext..ctor
MyProduct.DAL2.MyProductEntities..ctor