Re: SOT: MS SQL Server and "bulk insert"

2007-02-09 Thread Rick Root
On 2/9/07, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > > Rick, wow, is this just for backup purposes? What an odd process for DB > replication! No, our mainframe experiences several hours of downtime at night (like from 2-5am). It could run 24/7 but nobody in OIT wants to do that. P

Re: SOT: MS SQL Server and "bulk insert"

2007-02-08 Thread Robertson-Ravo, Neil (RX)
--Original Message- From: Rick Root To: CF-Talk Sent: Fri Feb 09 01:37:54 2007 Subject: Re: SOT: MS SQL Server and "bulk insert" On 2/8/07, Scott Weikert <[EMAIL PROTECTED]> wrote: > > Anyone out there who's made use of the "bulk insert" functionality in MS > S

Re: SOT: MS SQL Server and "bulk insert"

2007-02-08 Thread Rick Root
On 2/8/07, Scott Weikert <[EMAIL PROTECTED]> wrote: > > Anyone out there who's made use of the "bulk insert" functionality in MS > SQL Server - reasonably extensive use - please drop me an email > off-list. I've got some questions, specifically to do with mixed > delimiters, using quotes to get aro

SOT: MS SQL Server and "bulk insert"

2007-02-08 Thread Scott Weikert
Anyone out there who's made use of the "bulk insert" functionality in MS SQL Server - reasonably extensive use - please drop me an email off-list. I've got some questions, specifically to do with mixed delimiters, using quotes to get around mixed delimiters, and using the "text" datatype with B