Home All Groups Group Topic Archive Search About

Mapping from flatfile to SQL server database...

Author
30 Dec 2005 10:22 AM
Christian Johansen
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?

Author
30 Dec 2005 10:33 AM
David Portas
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
--
Author
30 Dec 2005 11:04 AM
Christian Johansen
Show quote
"David Portas" wrote:

> 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
> --
>

Ahh, just what I was looking for!
Thank you very much. Merry Christmas :)

AddThis Social Bookmark Button