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. Plus,

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 Bulk

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 around

Re: SOT: MS SQL Server and bulk insert

2007-02-08 Thread Robertson-Ravo, Neil (RX)
- 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 SQL Server - reasonably extensive use - please drop me