Solved

Application to read text file periodically and import it to Sql 2008r2 table

Posted on 2014-02-10
5
464 Views
Last Modified: 2016-02-10
I  am having a cobol application in novell s/w.  which periodically exports live data into a text file in mapped drive which can be read by windows os. My job is  to read this text file in the mapped drive and import into sql server in windows os.

I think the same can be achieved thro'  integration services.  Can expert suggest which one of the following is better

               1.  handling it thro integration services
                2.  Writing  a separate vb.net application to achieve the desired result

The application should handle , data transportation errors and any other import errors gracefully and rollback the import in case of any error and thro up errmsg to the user.
0
Comment
Question by:venkataramanaiahsr
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 39

Accepted Solution

by:
Pratima Pharande earned 400 total points
ID: 39849304
I think integration services is better option
you can handle data transportation errors  also you can coolect the bad data rows separately in log file and process the correct data only.
You can mail the log file from SSIS package
also you cna schedule the package to run perodicaly
0
 

Author Comment

by:venkataramanaiahsr
ID: 39849816
The output fromcobol application is in .sdf file which  can be opened in in notepad. the delimiter for the various columns is ~ . but when I try to create file connector in ssis, it is taking everything as single column.  what might be the issue
0
 
LVL 16

Expert Comment

by:Surendra Nath
ID: 39849890
you have to use a delimited file and select the delimiter as ~, in the file source.
0
 

Author Comment

by:venkataramanaiahsr
ID: 39851037
In the source file , the columns fields are separated by delimiter as ~ .  still every thing comes in one column when opened in ssis thro file connector.

But if the same file is opened in excel with delimiter as ~ , it comes in different columns
0
 
LVL 16

Assisted Solution

by:Surendra Nath
Surendra Nath earned 100 total points
ID: 39851577
watch this video
http://www.youtube.com/watch?v=1pOlNR-Zqdk

it will have more information regarding how to read a delimited file in SSIS.
Although he is showing about comma delimited, you can change it to ~ with ease.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question