|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Mapping from flatfile to SQL server database...Hi!
Im trying to find existing software to map from flatfiles (mostly .txt) to a database running on MS SQL Server. The files are recieved by mail, and made available to my program, and are supposed to be read and processed in a way that extracts the data from the files and inserts it into the database. If I had the time and skill, I would love to do this myself, but under the current circumstances i need to find some sort of existing SDK to do this (or an easy way to program it). Any suggestions? Christian Johansen wrote:
> Hi! Have you considered using DTS or Integration Services?> Im trying to find existing software to map from flatfiles (mostly .txt) to a > database running on MS SQL Server. The files are recieved by mail, and made > available to my program, and are supposed to be read and processed in a way > that extracts the data from the files and inserts it into the database. > If I had the time and skill, I would love to do this myself, but under the > current circumstances i need to find some sort of existing SDK to do this (or > an easy way to program it). > Any suggestions? http://www.sqldts.com/ www.microsoft.com/sql/technologies/integration/default.mspx Alternatively, there are many integration tool vendors whose products will do the job. Here is a selection: www.abinitio.com ibm.ascential.com www.datamirror.com www.datawatch.com www.embarcadero.com www.informatica.com www.pervasive.com -- David Portas SQL Server MVP --
Show quote
"David Portas" wrote: Ahh, just what I was looking for!> Christian Johansen wrote: > > > Hi! > > Im trying to find existing software to map from flatfiles (mostly .txt) to a > > database running on MS SQL Server. The files are recieved by mail, and made > > available to my program, and are supposed to be read and processed in a way > > that extracts the data from the files and inserts it into the database. > > If I had the time and skill, I would love to do this myself, but under the > > current circumstances i need to find some sort of existing SDK to do this (or > > an easy way to program it). > > Any suggestions? > > Have you considered using DTS or Integration Services? > http://www.sqldts.com/ > www.microsoft.com/sql/technologies/integration/default.mspx > > Alternatively, there are many integration tool vendors whose products > will do the job. Here is a selection: > www.abinitio.com > ibm.ascential.com > www.datamirror.com > www.datawatch.com > www.embarcadero.com > www.informatica.com > www.pervasive.com > > -- > David Portas > SQL Server MVP > -- > Thank you very much. Merry Christmas :) |
|||||||||||||||||||||||