Parsing out content from multiple text files into SQL Server 2005 DB automatically
$100-150 USD
Terminado
Publicado hace más de 15 años
$100-150 USD
Pagado a la entrega
Parsing out content from multiple text files into SQL Server 2005 DB automatically
Hello,
I have multiple text files saved in a specified location on a daily basis. What I want is for the chosen vendor/freelancer to create a method where each individual text files will be loaded and parsed out into multiple tables in a SQL Server 2005 database. The chosen vendor/freelancer would be responsible for creating a tables and relationships for the database. I’ve included some sample text files along with the keyword Excel file. The keyword Excel file would aid you in creating the tables and relationships for the database. You can add or modify the field names has you like just make sure that the field name matches the content that is been populated. For those field names that I have “Create new record for every items that has? “Beside them means that, a new record need to be created.
Hints:
Create SSIS package with flat file source and OleDB destination and schedule it through SQL Agent Jobs. Use Foreachloop container to loop the folder where your files reside and import whenever it sees file.
Solution:
The application has to be built within SQL server 2005 environment!
Caution:
Before bidding and accepting this project please, make you sure you fully understand what is needed from you. Also, please provide your contact information so I could contact you if needed for further clarifications. (Communication tool like: Skype, and etc.. are ways of contact)
Thanks.
## Deliverables
Solution? will be open source.