Q: How to create a file with incremental sequence number dynamically in SSIS? I am trying to create a file dynamically like abc_id(sequencenumber)_t(timestamp), where I cleared off creating the timestamp along with its prefix , but I don't know how to create a sequence number dynamically while exporting the data from source table to .DAT format file.
I tried to do with an incremental procedure in a variable task but I didn't get correct output.
