title: Converting a Julian Date to datetime in Visual Studio (SSIS Package)
body: <p>I am trying to build an SSIS package to allow conversion of a Oracle Julian Date to a datetime field for a SQL server DB in MS Visual Studio 2013. What tool would I use to convert my current Julian field into a datetime?</p>
  
  <p>Specifically, I need to convert a date such as: 115365 to 12/31/2015,in my DB. I cant seem to figure out how to use a Derived Column to do so.</p>