Script to save to CSV from ODBC

[nightmare99]

I have a need to save a CSV export from an ODBC data source which I am struggling with. I have been using a tool called ODBCView but this only supports 1000 lines when run from a batch file, can I do this with some sort of powershell or vbscript? The query I run is below, I also need to ftp this file somewhere but have been struggling also with Microsoft's ftp command line tool (perhaps firewall related).

SELECT STOCK.STOCK_CODE, STOCK.DESCRIPTION, STOCK.UNIT_OF_SALE, STOCK.NOMINAL_CODE, STOCK.PURCHASE_REF, STOCK.SUPPLIER_PART_NUMBER, STOCK.LOCATION, STOCK.COMMODITY_CODE, STOCK.SALES_PRICE, STOCK.WEB_DESCRIPTION, STOCK.WEB_DETAILS, STOCK.WEB_CATEGORY_1, STOCK.WEB_CATEGORY_2, STOCK.WEB_CATEGORY_3, STOCK.WEB_IMAGE_FILE, STOCK.WEB_PUBLISH, STOCK.WEB_SPECIAL, STOCK.INTRASTAT_COMM_CODE, STOCK.IGNORE_STK_LVL_FLAG, STOCK.DEPT_NUMBER, STOCK.DEPT_NAME, STOCK.TAX_CODE, STOCK.ASSEMBLY_LEVEL, STOCK.LINK_LEVEL, STOCK.STOCK_CAT, STOCK.STOCK_CAT_NAME, STOCK.STOCK_TAKE_DATE, STOCK.LAST_PURCHASE_PRICE, STOCK.LAST_DISC_PURCHASE_PRICE, STOCK.AVERAGE_COST_PRICE, STOCK.QTY_IN_STOCK, STOCK.QTY_ON_ORDER, STOCK.QTY_ALLOCATED, STOCK.QTY_LAST_ORDER, STOCK.QTY_REORDER, STOCK.QTY_REORDER_LEVEL, STOCK.QTY_LAST_STOCK_TAKE, STOCK.QTY_MAKEUP, STOCK.LAST_SALE_DATE, STOCK.LAST_PURCHASE_DATE, STOCK.UNIT_WEIGHT, STOCK.HAS_NO_COMPONENT, STOCK.HAS_BOM, STOCK.INACTIVE_FLAG
FROM STOCK STOCK
WHERE (STOCK.INACTIVE_FLAG=0)
ORDER BY STOCK.STOCK_CODE

DSN=SageLine50v21;UID=username;PWD=password

Any ideas chaps?

 

[nightmare99]

Cheers gents, you have given me a couple of good options there. I will have a play over the next couple of days and update the thread accordingly