Import EDI text file into SQL Table | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Import EDI text file into SQL Table

I am not new to programming, but new to the SQL Server. I need to upload on a monthly basis a text file that has four different record types with different field layouts. I only want to pull one record type into my predefined SQL table. Along with that I need to convert some special characters to numeric values in several of my numeric fields. I was trying to do that with a "bulk insert" and "case" statements, but it’s not working. Any suggestions on what my easiest option would be? The contractor that originally set this up did the conversion in VB and tied it into SQL, but I don’t know how to do that and the file layout has changed, so I need to create something new. Can anyone help me get started? Thanks.
I suggest to use DTS.
Take a look of Books on Line (SQL tools).
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS” with no warranties for accuracy.
I’m not having much luck with DTS either. I guess I’ll go back to the books.
Some help: http://www.sql-server-performance.com/performance_monitoring_tutor_part3.asp
http://www.sql-server-performance.com/jk_sql_server_upgrade2.asp Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS” with no warranties for accuracy.
See if this helps
http://www.nigelrivett.net/SQLTsql/ImportTextFiles.html Madhivanan Failing to plan is Planning to fail
]]>