Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jholovacs
Posting Yak Master
163 Posts |
 Posted - 2009-06-10 : 14:03:56
|
I'd like to generate CSV extract files without using SSIS from a 64 bit machine on a periodic basis. I had the idea of INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Text;Database=c:\temp\;HDR=Yes;', 'SELECT * FROM Test01.txt');but the jet driver is not installed and I don't think I can install it on a 64 bit system... moreover, as this is a production machine, I'd prefer to avoid installing anything if at all avoidable.Anyone have any experience with this? Using the MSOLAP, MSDAOSP, SQLOLEDB providers or anything natively installed on a 64-bit OS and SQL Server?
SELECT TOP 1 w.[name]FROM dbo.women wINNER JOIN dbo.inlaws i ON i.inlaw_id = w.parent_idWHERE i.net_worth > 10000000 AND i.status IN ('dead', 'dying') AND w.husband_id IS NULLORDER BY w.hotness_factor DESC |
|
|
|
|
|
dumping to text file from 64-bit server?