I have a new wages exports process.
I need to export data to a text file for import into paycor
The text file consists of a header record (1 line)
detail records (however many employees...one per)
trailer record (1 line)
I have no problem creating the data....
However, I'm supposed to build this in SSIS.
So...in SSIS, should I build the three records seperately and then appeand the detail and the trailer record to the header?
Or Build the whole thing in sql itself?
need some direction in this.