Crow, Thanks for the info, that is very helpful.
I am using SQL 05 DTS is not really an option anymore. I had to use Integration Services to do it. I am guessing you can save the package and call it like you do a DTS package. Any ideas if it will function the same way. Thanks again for the help. >Here's what I do, start to finish: > >1) provide a file upload form > >2) upload the file to the file system via CF. Be sure to put it in the >folder that you specified in the DTS pkg you created, also making sure that >the file is named the same as the file you specified in the DTS pkg. > >3) run the DTS via a stored procedure - a complete tutorial on hoew to do >that with CF can be found here: >http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS (thanks >Dan) > >4) delete the file, or archive it, or whatever. > >That's about all there to it. The hardest part is setting up the SP call >from CF, and that is pretty easy too, thanks to the handy-dandy tutorial. > >Let me know if I left anything out. > > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287245 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
