Datetime conversion from Oracle to MSSQL problem in SSIS

One day I had a problem encountering some problem within SSIS using Datetime conversion especially when passing parameters from one flow to another.

One of the problem which intrigues me that this date time issue when I tries to input


It ran fine on my Evaluate Expression but when I ran my SSIS it came out this problem.

Error: The data types "DT_WSTR" and "DT_DATE" are incompatible for binary operator "+". The operand types could not be implicitly cast into compatible types for the operation. To perform this operation, one or both operands need to be explicitly cast with a cast operator.

What I did is to change my length to 50 and my variable to pass in as DateTime and everything ran successful.

The DateTime issue will encounter quite common on dealing with databases especially when you are handling different data sources. My advice will be always pass as DateTime rather than convert into string unless you absolutely have to. (eg. showing on UI)

My Dream Desk Setup for 2018!

Today is Chinese New Year Eve, I decided to tidy up my desk which I usually work most of my personal projects.

My dream desk setup is pretty simple. I want to keep it simple ergonomic and fun to stay long enough for me to enjoy my stuff.

So I bought my ultimate ergonomic desk the moment I move into my new place.

Everything looks great but... I was having some problem with the cable management problem.

Cables are so messy and my vacuum robot has some issue entering this area.

I was afraid that my vacuum robot might tangle the wire one day, I decided to do something about it.

So there are 2 problems here.

- Messy cables lying around.

- The Belkin surge protectors Power Strip that I bought took up that much space.

So I went online bought cable management, cable box, and cables ties to organize the cables.

Here you can see that I use my cable ties to tie up the power strip against the desk so that it won't take up space on the floor which makes it perfect for my vacuum robot to pass through the area.

The cable organizer helps me to make the cable looks less messy

For those remaining long cables will be stored in the cable management box.

Here is the end result.

One of the main reason I got this desk is that I can use it as a standing desk most of the time. It has 4 memory storage so that you do not have to figure out what was your configuration for sitting and standing height.

Beautiful isn't it?

Watch it in action!