ETL and Data Integration tools - Modern ETL software for everyone

Dear Supporter

I have a daily FTP file that have naming like [XXX_YYYYMMDD.txt]
and in my DB have field of TXN_Date that keep date from filename.
Is application have any feature to support my case?

Thank in forward

Not sure exactly what you are doing over there.

lf you are loading data from the file into the database
you can get file name by using reader parameter transformation function.

of you just want to get the file name you can use file system as a data source

Also watch our online tutorials they will answer most of your questions.

Mike

Dear Supporter

- I have another question. If I get a daily package that contain more than
1 files and file name is dynamic (by date).Example
I get FTP file Folder contain 3 file
1. X1_20101104.txt
2. X2_20101104.txt
3. X3_20101104.txt

I need to get auto load file X2_YYYYMMDD.txt for everyday with Package "AA.ats"
and load file X3_YYYYMMDD.txt for everyday with Package "BB.ats".
How can I do this?

- I want to get the total records that tranfers from text file to DB. into log table. Can I do this and how?

Sorry I cannot find solution on your manaul.

1.
- I have another question. If I get a daily package that contain more than
1 files and file name is dynamic (by date).Example
I get FTP file Folder contain 3 file
1. X1_20101104.txt
2. X2_20101104.txt
3. X3_20101104.txt

I need to get auto load file X2_YYYYMMDD.txt for everyday with Package "AA.ats"
and load file X3_YYYYMMDD.txt for everyday with Package "BB.ats".
How can I do this?

specify a mask X1_*.txt to load first file
X3_*.txt to load second file file

2
- I want to get the total records that tranfers from text file to DB. into log table. Can I do this and how?

You can do a lot...

you would need to use following sequence

the transformation will have two data writers
one of them connected to the table you are loading data into
another connected to the log table

than for the first data writer
data reader=>validator 1 =>transformation 1=>data writer 1

second data writer

validator 1=> transformation 2 => Groupper >= Transformation 3 => data writer 2

Within transformation 2 add

Sequence object to generate Line no
Data reader parameter to get the file name

Than within groupper
group by file name
use MAX of line to get number of records.

May suggest to watch all our online tutorials they will save you a lot of time

Mike

Dear Mike
I found application error like app hang

To be honest I an not able to see anything in your screenshot...

Can you post another one with better resolution or email one to us

Mike