Hello, I have been asked to amend the SQL functions of a ColdFusion application, after transferring the underlying tables from IBM Informix to Microsoft SQL tables (for performance reasons).
I have already tried to import the daily backup text files having pipe (|) as column delimiters, but since the column data contains CR/LF control characters, I cannot use the same as row delimiters used by many import routines (e.g. using SQL 2005 Server Management Studio). I will be most grateful if anybody can suggest a tried and tested method of how to import data from Informix to MS-SQL tables, please. Many thanks. Kamru ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315514 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
