I'm planning on creating a TSQL view containing data that will be extracted by SSIS. The first section of the view is to be a header section of about five fields. The next four sections will be the body of the data containing anywhere from eight to thirty fields. The final section will be a footer of about three fields.
First, is it possible to create a TSQL view containing sections with different numbers of fields like this? If not, what other solutions are there? I have created views many times in the past, with UNION ALL statements, but each statement separated sections that contained an equal number of fields.
Secondly, is it possible to tell SSIS to not pull column headings when extracting data from SQL?
Ultimately, I want to create a text file from SSIS that will be uploaded by a bank. Banks have very strict requirements as to the format of the data in such files.