SSIS to create text file

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.
lrbristerAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
lrbristerAuthor Commented:
Maybe I should have been more specific.
I need to marry the
1 header line which is fixed width 6 columns
Many detail lines which is fixed width's 10 columns1 Trailer line which is fixed width 4 columns

So...
In SSIS, can I get the three in sequence, and then append the 3 segments or files together?
0
 
liijaConnect With a Mentor Commented:
I think you were specific enough.

If they are fixed, it should be fairly straight forward.
Write data to 'data'file in Data Flow task, then append the files into one with Execute Process task (data + header and footer)
0
 
lrbristerAuthor Commented:
Thanks
0
All Courses

From novice to tech pro — start learning today.