Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Import txt file in Data Migrator
Go
New
Search
Notify
Tools
Reply
  
Import txt file in Data Migrator
 Login/Join
 
Gold member
posted
Does anyone knows how to import a flat file(comma delimited file) using data migrator with sql server as destination?


Shirley Huang
WF 7.7.04M MRE BID DevStudio
WIN2003, SQL Server 2000/DB2
HTML/PDF/EXL2k/AHTML
iSM 6.16
 
Posts: 55 | Registered: May 05, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Yes. Do you have a master created for the flat file? If not, you'll need to do that first. Depending on how your flat file was created, a COMT, COM or DFIX master would probably be your best bet. I'm assuming you already have a data adapter and masters created to access your SQL Server tables. If not, do that too. Once that's done, just create your data flow as normal. If you've never created a Data Migrator data flow before, then I'd recommend you talk to your management about some training.


Data Migrator 5.3, 7.1, 7.6
WebFOCUS 7.1, 7.6, 7.7
SQL Server, Oracle, DB2
Windows
 
Posts: 126 | Registered: January 18, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Import txt file in Data Migrator

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.