You can use script task(c#) to do this.

String sFileName = "CCCLOC_DDDLOC_LOC_20151203_240000_trigger.txt";

...

michal.lisinski (10/16/2015)

---

Hi

I'm glad to see you find your own workaround of problem, but please think about error handling

to this task. Sometimes the name of file can be totally...

Thanks for quick response Michal. I got it to work in another way. Just in case if anybody needs I am posting here my whole code.

String sFile_Path = Dts.Variables["User::Suppress_Desti_File_Path"].Value.ToString();

...

Hi guys,

Below is the code I have used to pick the latest file from folder and I am able to work it out.

ElseIf Fil.LastWriteTime > lastModified Then

...

tush002sunny (9/21/2015)

---

Hi,

I'm stuck with the thing where I don't know what to use for reading count in header of .csv file as source and compare it with acutal number...

Have you set OverwriteDestinaton as TRUE.

Luis Cazares (7/9/2015)

---

p.shabbir (7/9/2015)

---

You can also define that column as a date in the connection properties for the file and get the error in there.

Either way, you're reading the whole...

You can also define that column as a date in the connection properties for the file and get the error in there.

Either way, you're reading the whole file and validating...

Luis Cazares (7/7/2015)

---

It depends.

The best way would be to have your DOB column in your table as a date data type. This will validate that the data is correct and...

Phil Parkin (4/21/2015)

---

OK, I'll give you an outline. There will be many ways of achieving this, some of which will have fewer calls to the DB engine, but here is...

Phil Parkin (4/21/2015)

---

p.shabbir (4/21/2015)

---

Hi phil,

Thanks for the quick response. I know that one DFT per file will do but, what if we have more files(Say 50 or 100 files). It...

Hi phil,

Thanks for the quick response. I know that one DFT per file will do but, what if we have more files(Say 50 or 100 files). It will be pain...

Yes, data coming from flat file.

Thanks for the reply phil.

Yes, always there will be 3 items and column length is not fixed.

It may be varied for example

ABCDE|ABCDF|BCDEF

BCDEF|ABCDF|BCDEF

ABCDEF|ABCDF|BCDEF

ABCDE|ABCDFE|BCDEF

Thanks

Thanks for the reply Koen.

Can you let me know how to get 2nd and 3rd string?

ABCDE|ABCDF|BCDEF

result 2nd string

----------------

ABCDF

result 3rd string

----------------

BCDEF

Thanks for your help.