I have a JDE julian date that I need to convert to short date in a derived colums data flow task.
An example value of the date in the sql database is 111222. (08/10/2011)
The JDE julian date is 6 digits. I can create a function in sql server to do this but the
dba doesnt want any functions in that particular db.
So I need to figure out how to do this in the IDE for SSIS. Im not sure if there is a place to write
a custom function in the IDE or if I have to use the built in functions to try and convert.
See attached screen.