srajeevkumar
IS-IT--Management
Hello freinds,
We get a raw text file from one of our suppliers with some production information details. At the moment I use DTS to only read the text file as a text file dump into a table in our database. Now I have a VB application that looks at this table and then based on various criteria slit each line of rcord into a header and data table by selecting the appropriate fields and also creates enough number of data records against each header.
I was just wondering on how not to use VB in any stage and rather using more tasks within the SQL server to completely manipulate the data and split it into header , data form.
Has anyone used DTS tasks to do these kind of things please.
Any advice or help is more than welcome.
Rgds
Rajeev
We get a raw text file from one of our suppliers with some production information details. At the moment I use DTS to only read the text file as a text file dump into a table in our database. Now I have a VB application that looks at this table and then based on various criteria slit each line of rcord into a header and data table by selecting the appropriate fields and also creates enough number of data records against each header.
I was just wondering on how not to use VB in any stage and rather using more tasks within the SQL server to completely manipulate the data and split it into header , data form.
Has anyone used DTS tasks to do these kind of things please.
Any advice or help is more than welcome.
Rgds
Rajeev