April 22, 2008 at 11:00 am
Hi I have 3 queries
1) I want to retrieve the name of the file (.txt) dynamically which is located at the ftp location and then insert that name in a table which is created in Oracle anyone pls if can share some idea will be of a great help
2) How can I place file from my shared folder to the FTP Location using ActiveX
3) How can i place a filename in the 'TextFile(Source) Connection properties using Active X bcus these files will be dynamic (Ex. aaa0408.txt where in the last 4 digits are month and year)
HELP NEEDED URGENT
April 22, 2008 at 2:48 pm
If you actually mean DTS, I'm not sure what to do. If you mean SSIS (which I'm assuming because of the forum you posted this in), then take a look at the ForEachNext object in SSIS. It can loop through file names, store the file name (including the path or not) in a variable, and perform actions based on various options.
SSIS can move files around (FileSystem actions), insert file names into a table (DataFlow), etc.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply