I'm migrating a DTS package to SSIS. In the DTS, I have an ActiveX Script that set a variable (filename with date and time as the file extension) and a Dynamic Properties Task that set the filename to a Text-File destination feeded by a Transform Data Task that uses a SQL query that extract and format the data to the required field-length. That works fine.
Now, I need to do the same in SSIS. Flat-File Connection Manager ask for an existing file. But this file is created by the DTS, it doesn't exist yet. And anyway, filename should be dynamic.
I tried Raw File, where I can select a variable as filename, but the output is binary.
The result file is imported by a SAP ERP system, so it has to match the required fix field-length.
how can I do this in SSIS?
thanks for your time and help