I am generating the Output-Path for FlatFiles dynamically.
I require a file name of the form YYMMDD_name.txt.
For testing purposes I optionally generate the alternative version TEST_name.txt.
I can change the setting from Test to YYMMDD(Release) using a boolean in a config file.
This works pefectly using Expressions from within Visual Studio.
I have two config files, one for TEST and one for YYMMDD.
dtexec /File Package.dtsx /Conf TEST.dtsConfig
dtexec /File Package.dtsx /Conf YYMMDD.dtsConfig
I am now executing the YYMMDD version from command line (Config Value Test=0).
I then get some files of the form TEST_name.txt and some with YYMMDD_name.txt.
I believe the config is not loaded properly until the process has nearly completed.
Out of 20 files a maximum of 5 were generated correctly, mostly 0-3.
Does this ring a bell? I am rather confused and have no idea what to do.
View Complete Post