K, I had a look at SSDT and had a stroke...  So in place of that I recreated my DTS package and saved it within Sql Server.  It takes an Excel file from another server and dumps it into a SQL Database.  When I run the package from Integration Services it executes with success... I can run it multiple of times with success.

However, once I place it into a Job within the agent and execute the job it fails every time.

I appreciate the assistance.