I'm using it to allow a member of our site to transfer data between two tables. They can select the fields to transfer so its rather dynamic. My plan was to generate the temp file containing the data to transfer using the COALESCE and CAST functions to generate the file. Then, I wanted to run the Bulk Insert to insert the data.
Would I generate the DTS package the same way? Brook At 07:43 PM 09/09/02 -0400, you wrote: >If you have control over the server, why not execute a dts package via >a stored procedure? It's so much easier... > >-- > jon > mailto:[EMAIL PROTECTED] > >Monday, September 9, 2002, 7:13:02 PM, you wrote: >BD> I wonder if any one can help with this one. SQL Server management is >not my >BD> strongest skill :) I'm using a SQL Server login account via CF (cfuser). >BD> When I create a table via CF, the tables owner is "cfuser" rather than >DBO. >BD> This is fine, until I try to do a BULK INSERT and get an error on the >BD> opentable statement. I can run the BULK INSERT on any of the tables owned >BD> by dbo. > >BD> I set up a new account, with sys_admin privileges and even this >account can >BD> not run the BULK INSERT. Another funny thing is the owner account >(cfuser) >BD> can also not run the BULK INSERT. Does any one know why this would be? > >BD> Thanks :) >BD> Brook Davies > > >BD> > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
