Question SQLFileExport MaxFileSize issue

Hi,

I work with 18.3.9 designer
I'm trying to use SQLFileExport in order to split a table in multiple files, with File size 10M max.
I use Sql Exp Filename to define the pattern name , and Sql Exp Max File Size to define 10M
I Got an issue due to the namming of files, because the increment comes after extension files (.csv in my case)
How can i solve it ? renaming files ?
Is it possible to chosse extension pattern for files we create ? (.txt, .csv , ...)

Thanks.

Hi,

when using Max File Size, the number of the file is added at the end of the file name as you noticed.
The solution would be to rename the files after the generation.

I would suggest to use SQLFileExport without any file extension, and at the end, use a WaitForFile that you would bind to a Move File Action that would add the required extension.

Hi Pierre Olivier,

That's what i'm doing actually but i was thinking it's a bit loud.
Ok, i keep on using it.
Is it impossible to fix the problem in the SQLFileExport box ? adding the extension by using metadata or parameter after adding the sequence number ?
Thx.

Hi,

yes the enhancement request has been filled to R&D Team.
It will be implemented in a future release of Stambia.

Best,