Focal Point
Import txt file in Data Migrator

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/2881089962

February 05, 2008, 10:46 AM
Shirley
Import txt file in Data Migrator
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
February 06, 2008, 08:53 AM
Jessica Bottone
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