is250sp (7/15/2014)
This is only my 2nd package so any help would be much appreciated. It's a very simple package consisting of a single Data Flow Task. Within the task are 2 objects...OLE DB Source and Flat File Destination. In the OLE DB Source, I have a SQL Command Text with the below scriptselect a.personnum,a.first_name,a.middle_init,a.last_name
,convert(varchar(10), a.hire_dt, 101) as hire_dt
,a.base_wage,a.status,b.locss as location
,a.locss_id,a.supervisor_locss_id,a.locss_pw,a.locss_sec_lvl
from LOCSSDemographicData a
left outer join e2l_loc_xlat b on b.etime = a.location
order by 2
When I click on Preview, it shows the Hire Dt as "mm/dd/yyyy". In the Flat File Destination, it's pointing to a Flat File connection manager called "etime_to_locss.txt". When I open the "etime_to_locss.txt" connection manager, and click on Preview, it shows the Hire Dt column as "yyyy-mm-dd 00:00:00".
This doesn't really help. All you are showing me is the query you run in a SQL Command text. I still don't see what you see which is the actual SSIS package, the tables queried by the SQL script, the file you are creating on output. Anything I suggest is just shots in the dark with little chance of really helping.
That's why I said SSIS packages is one of the hardest things to help with on a forum.