DSXchange

Thanks guys for pitchin in quick ! DSguru2B's example is what solved the issue for me... Timestamp: I isolated Day Month & Year into 3 seperate stage variables and then appended each of them in the format i needed along with the timestamp aswell. i.e : SV_YEAR:'-':SV_MON:'-':SV_DT:' ':' 00:00:00...

Hi Folks, I've been working to solve two issues, but haven't been successful as yet. So, decided to lay down the issue here to see if anyone can help me: 1) ETL Map Source : Flat-File ETL Map Target : SQL Server 2005 Table There's a field in the flat file with values similar to -> 9/28/2007 (mm/dd/y...