Joe, To be frank, I can't program in any of those languages. DTS could possibly work, but I think that it would take some pretty fancy Transact SQL to take the big flat files that we get and perform all the appropriate Inserts/Updates into the 10 to 20 normalized tables that the data relates to. Which is why I wrote it in CF, cause I know how to massage data in CF.
>Why would you want to use CFMX/JRun to schedule anything? > >If you are doing data imports, why not use DTS or database scheduled job >utils? >If that is not possible, you could write a standalone Java/C#/VB application >and >schedule it via the operating system. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196216 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
