Write file target file name

Hi Maarten,

Can you show the Input for this parameter in the Software Factory, and if this is assigned a variable, how that variable get its value?

Hi Mark, the value of the variable is an nvarchar and gets set like:

set @xml_file_naam = (
                      select 'JP_'
                            + cast(jp.journaal_post_id as varchar)
                            +'_DATE_'
                            + format(getdate(), 'dd_MM_yyyy_HH_mm_ss')
                            + '.xml'
                        from journaal_post jp
                       where jp.journaal_post_id = @journaal_post_id
                     )
select @xml_file_naam
 

Are you sure your process variable is holding that value?

If you are filling it with a process procedure the variable must be marked as "Process output available”.

Another thing that happens frequently is that the process variable is not linked as the "input” variable in the Write File Connector.

Can you double check if this is the case?

@Dick van den Brink  I think both are as they should be configured
But thanks for the tip :)

Have you found the solution @Maarten?