How to dynamically give flat file source file name in session properties of informatica?

flat-file informatica-powercenter informatica
Aspirant picture Aspirant · Oct 28, 2012 · Viewed 26.2k times · Source

i have an issue where i get flat file with date and time extension to flat file name like test_28-10-2012.txt

I can get the flat file name in mapping through checking the AddCurrentlyProcessedFileNameproperty in Source Analyzer,from there i can do my logic but my question is

how can i dynamically give the flat file name in Source file name property of session.

Answer

Raghav picture Raghav · Oct 29, 2012

One way to do this is to use indirect sources. You can configure your session to use indirect sources, wherein the source file names are coming from a text file (each entry in the listfile is a source file session will read).

Then you can arrange your code to add that dynamic filename to that listfile.

Related questions

How to import a fixed width flat file into database using SSIS?

Does any one have a tutorial on how to import a fixed width flat file into a database using an SSIS package? I have a flat file containing columns with varying lengths. Column name Width ----------- ----- First name 25 Last …

Read More
Flat file databases

What are the best practices around creating flat file database structures in PHP? A lot of more matured PHP flat file frameworks out there which I attempt to implement SQL-like query syntax which is over the top for my purposes …

Read More
SSIS - Flat file always ANSI never UTF-8 encoded

Have a pretty straight forward SSIS package: OLE DB Source to get data via a view, (all string columns in db table nvarchar or nchar). Derived Column to format existing date and add it on to the dataset, (data type …

Read More