After uninstalling Microsoft office I am getting the following error in SSIS when attempting designing the script.

TITLE: Microsoft Visual Studio
------------------------------

Cannot show the editor for this task.

------------------------------
ADDITIONAL INFORMATION:

Specified cast is not valid. (Microsoft.VisualBasic.Vsa.DT)

------------------------------
BUTTONS:

OK
------------------------------

To Fix this I just reinstall Microsoft Office and it all works again. I think this is because the design script is using VB script this is why it is causing the error.

When using data conversion component in dataflow becareful that the data you trying to convert to is valid, otherwise you may get an error like this:

1. Error 1 Validation error. Data Flow Task: No update required [22340]: input column "gms_valueConverted" (23080) has a datatype which cannot be joined on