> I would like to do a bulk insert into SQL Server 2000 from an XML file. > > ... > > My Query looks like this: > <cfquery datasource="db_events" name="doInserts"> > BULK INSERT tbl_EventPerformers > FROM 'D:\Websites\globalFunctions\getEventPerformers.txt' WITH > (FORMATFILE='D:\Websites\globalFunctions\getEventPerformersMapping.xml') > </cfquery> > > The error I'm getting is this: > [Macromedia][SQLServer JDBC Driver][SQLServer]Could not bulk insert. Unknown > version of format file > 'D:\Websites\globalFunctions\getEventPerformersMapping.xml'.
Is the database server on the same machine as the web server? Because, otherwise, the filesystem path won't resolve for the database server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:317028 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
