Dynamically name file

This feature allows you to Create a new file for every session run create a new file for each transaction. Informatica provides a special port,"FileName" in the Target file definition. This port you have to add explicitly.

See the below diagram for adding the "FileName" port. Tags Informatica. You might like Show more. Vijay Bhaskar 07 March, Yseen Mohammad 13 April, TariniRout 03 April, Unknown 08 April, Unknown 30 September, From programming to databases with Excel VBA to deliver business-grade solutions. Click the button to see the complete program and start now! Are you automating annual Workbooks, monthly PDF reports, or producing any other dynamic files with Excel?

Your program needs to automatically save each file in a folder. Here is how you can construct the full path and filename with a couple of VBA functions. What is a dynamically constructed file name? When do we need to dynamically construct file names?

The following are all examples of cases in which I needed to construct file names as part of projects producing reports of all sorts: A PDF report is needed to be temporarily stored on disk before it can be emailed see how to create PDF reports with Excel VBA here.

A customer PDF report needs to be archived for future reference. A customer lab results data-set needs to be archived for future retrieval and processing. A monthly financial report needs to be saved as a separate Excel Workbook, generated from the main tool for managing financials.

Changing the content in Reportserver Database does not seem to be a feasible solution to me. I do not want to think of what could happen if the subscription execution fails for any reason.

If I understood it correctly, this solution will also only work if you want to set the reportname only once per execution of the subscription and then back to origin. If you want to set it for every entry in the data driven subscription source query you will have to change the data during the execution of the subscription, which would be only possible using a stored proc as dummy datasource which does this any time the report is executed You must be logged in to reply to this topic. Login to reply.

March 21, at pm Jason L. March 22, at am I've been trying to figure out how to do this at work for ages! Thanks a ton for the tip! Do you know of any other better way to do this?? Asked by:. Archived Forums. Sign in to vote. HI , i am loading the data from excel as source to sql server table as destination. Friday, August 31, PM. Proposed as answer by Yang.