import text files

Question

import text files

jishnu

SSC Enthusiast

Points: 129
More actions
October 18, 2002 at 9:25 am

#105803

Hi,
I would like to know if there is any way to
import a file on a automatic manner. We have to check if the file exsist everytime.
And the file name changes to.
Jishnu

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

mhweiss SSCarpal Tunnel Points: 4284 More actions · Answer 1

Look back in the DTS forum here for the posting entitled Changing the Source File in DTS. I have code posted there that will do exactly what you need although you will have to modify it slightly to fit your exact situation...

hth,

Michael

Michael Weiss

jishnu SSC Enthusiast Points: 129 More actions · Answer 2

thanks ,

but these files change name with the

date they are posted .

any solution

mhweiss SSCarpal Tunnel Points: 4284 More actions · Answer 3

Obviously, the files have to change name according to some set logic in order to program a dynamic file selection. Or the files have to have a naming pattern so that you can find them in the directory. Either way, you can do this dynamically at run time via an ActiveX script similar to the one I posted a while back. Perhaps if you can give us an example of the file names and how they change we can steer you down the right path. I use an ActiveX script to import files whose names change based on julian date, for example.

Michael

Michael Weiss

pop SSCrazy Points: 2130 More actions · Answer 4

Hi,

I have the same problem, just need to check to see if file exists, and if so continue and rebuild tables, or else quit the package.If either of you could repost or a link to the thread where it was answered that would be great.