What is happening when you attempt to use it? We use it a great deal in a
shared server environment to do bulk inserts of text files and Access 97
databases into SQL Server 7. The only issues we have run into has been user
permissions, since we are uploading files to the web server via CF and then
needed to execute the DTS package on the SQL Server. Our work around for
that is to use a stored procedure to copy the files from one box to the
other and to setup permissions on the boxes to allow the SQL Server to
connect to the web server via FTP.
Snipe - <CF_BotMaster Network="EFNet" Channel="ColdFusion">
----- Original Message -----
From: "Marc Garrett" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, June 11, 2001 6:34 AM
Subject: Re: CFSTOREDPROC and performance question
> Thanks Aaron.
>
> DTS was my first attempt but it will not work on this shared server with a
> text file.
>
> Regards,
>
> Marc Garrett
>
> ----- Original Message -----
> From: "Aaron Rouse" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Sunday, June 10, 2001 9:58 PM
> Subject: Re: CFSTOREDPROC and performance question
>
>
> > Or DTS and you could schedule a Job to execute it whenever.
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
