Hiya all,

I managed to just get the filename using the following code

Public Sub Main()

Dim SourceFileName As String = Dts.Variables("FileWeJustFound").Value.ToString()

...

Thx guys I got it working but the filenames that get entered say file1.csv file2.csv file3.csv

How to i change Script code to remove the .csv and just leave file1,file2, etc.

Thx...

Hiya and thx for replying.

I have added your code to a script task but how to I now use this new variable in a derived column task? I can only...

Hi Again Guys..

I have been using the procedure you gave me with no trouble so far.. But now I have an issue with NULLS

As discussed I create a temp table...

Thx for the reply guys..

So you think that using DTS is overKill ?

I did try to create a table using "create into" but It will not let me over write...

Can anybody even give me an idea of how to do this ?

Ray..

Hiya Guys thx for the help..

I have the following working.. The syntax for btrieve current date is curdate()

In Btrieve itself if I run the following it comes back with results...

Thx For the Reply Guys that worked !! I'm Nearly there.

I also need to use a 'where' so That I can select the Last 3 Months of records eg: where date_booked >=...