Hi, this is my first post here so please be easy on me 🙂
I am polling an ftp site for a file (ie MyFile.txt), that file is a delimited flat file which i was able to get biztlak to parse. How to setup biztlak that it polls for changes to the file, not just if the file exists?
So what I need to do, is select bunch of ID’s from a database table, then i need to insert the data in the file per each ID. So for example if the file contains 100 records and there are 5 ID’s in my SqlServer table, I want to insert 500 records into a table.
To complicate this just a little further, the flat file has two columns and the table with ID’s also has two columns. Depending on the 2nd column from the database table, I either want to insert all records (DBTable.ID,File.ColumnA) or (DBTable.ID, File.ColumnB) from the flat file (for each ID i retreive from the databse)….Not sure if that makes sense, i hope it does.
Hoping someone knows how to proceed with this sorta thing. Thanks for all the help in advance