DTS FLAT File
-
Hi all, How to use DTS Flat file provider for reading a text file data and fill dataset.I know how to get using OleDB providers.But i do not how to use DTS Flat file to read a text file using delimiters and fill the dataset. If body have any idea please reply back. thanks in advance. Sastry. sastry ch
-
Hi all, How to use DTS Flat file provider for reading a text file data and fill dataset.I know how to get using OleDB providers.But i do not how to use DTS Flat file to read a text file using delimiters and fill the dataset. If body have any idea please reply back. thanks in advance. Sastry. sastry ch
DTS in its simplest form will convert your flat file using the delimiters, into fields of a table. When creating a DTS package it has a handy wizard that will walk you through matching up fields(simular to a excel import process) Then go into your c# form and make a connection to that database where that table is located and select what you want and adapter.fill(dataset) kinda thingy. -Joshua Lunsford