Hi,
We have an app in .NET with sql server 2005 backend and would need to
import relatively huge amount of data from disparate providers on a
nightly basis.
What is the file format that is preferred and please help me understand
why we need to go with a specific format? Is it XML, CSV, or anything
else? We have been leaning towards using XML
If it is XML, how can we a template for the XML file (is it the XSD
schema file?) and pass it to the providers so that we can get formatted
data without much discrepancies?
Thanks in advance!
We have an app in .NET with sql server 2005 backend and would need to
import relatively huge amount of data from disparate providers on a
nightly basis.
What is the file format that is preferred and please help me understand
why we need to go with a specific format? Is it XML, CSV, or anything
else? We have been leaning towards using XML
If it is XML, how can we a template for the XML file (is it the XSD
schema file?) and pass it to the providers so that we can get formatted
data without much discrepancies?
Thanks in advance!