My request is that a file be generated regardless of the data. I tried several different options in S3 stage, but nothing worked.
Ah, yes, have encountered this quite a few times. Is there any way for you check if there is no data? If not, can you just dump out a file with column headers or something?
Sorry for the late reply.. my file which is getting created daily will not have data sometimes and when the data is not there, file is not creating. I just need the file created with columns.
You can use the query to scalar component to run a query for the count or records and store it into a variable. Then check if the variable is > 0, if yes, then dump out a file. If not, then just create output a file with column headers. You can store the column headers in a variable or in another table.
Just some ideas...haven't really thought through it.