Usint SQL Server Data Transformation Service, I would like to put data into my template Excel, and after rename the file under a new name (Save As..).
How can I do that? Do I have to use parameters in DTS? How that it works?
I appreciate and sample please. Thank you.