Unfortunately, I don't get the opportunity to use SQL 05 yet, we're still on 2K, so I'm not sure how you'd do it from there. I bet someone here can answer tha tho. I'd personally like to know myself. Good luck!
On 8/27/07, Steve Sequenzia <[EMAIL PROTECTED]> wrote: > > 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. > > > > > >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287248 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
