Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id B59829FB566 for ; Mon, 22 Jan 2007 21:15:55 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 26240-09 for ; Mon, 22 Jan 2007 21:15:42 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 828F39FB531 for ; Mon, 22 Jan 2007 21:15:52 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from rrmailscan3.safenetbox.biz (unknown [203.25.40.75]) by svr4.postgresql.org (Postfix) with ESMTP id 6E44F5AFB22 for ; Tue, 23 Jan 2007 01:15:50 +0000 (GMT) Received: from rrmailscan3.safenetbox.biz (rrmailscan3.safenetbox.biz [127.0.0.1]) by rrmailscan3.safenetbox.biz (Postfix) with ESMTP id 3010A1D4842E for ; Tue, 23 Jan 2007 12:15:43 +1100 (EST) Received: from [172.17.2.14] (online4-new.lnk.telstra.net [139.130.169.227]) (Authenticated sender: remote) by rrmailscan3.safenetbox.biz (Postfix) with ESMTP id 8DF791D4845B for ; Tue, 23 Jan 2007 12:15:42 +1100 (EST) Message-ID: <45B5619A.6040404@autoledgers.com.au> Date: Tue, 23 Jan 2007 10:15:06 +0900 From: Paul Lambert User-Agent: Thunderbird 1.5.0.8 (Windows/20061025) MIME-Version: 1.0 To: pgsql-ports@postgresql.org Subject: M$ SQL server DTS package equivalent in Postgres Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.27 tagged_above=0 required=5 tests=AWL, BAYES_50, UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200701/3 X-Sequence-Number: 2511 G'day, Is there an equivalent in Postgres to the DTS Packages available in M$ SQL server. I use these in SQL server to pre-load data from CSV files prior to enabling replication from my primary application. Any pointers on where best to go for this would be appreciated. I'm reading about something called EMS, is that the way to go? Sample of one of the files I use: DEALER_ID^DATE_CHANGED^TIME_CHANGED^BILLING_CODE_ID^DES^BILLING_CODE_TYPE^LABOUR_RATE^LABOUR_SALES_GROUP^CUSTOMER_NO^PARTS_SALES_GRO f UP^COMEBACK^WORKSHOP^FRANCHISE^LOCATION^DELETEFLAG F65^23-Jan-2007^10:13^AA^ADVERSITING ADMIN^I^45^40^2196^18^^0^BLANK^0^ F65^23-Jan-2007^10:13^AN^ADV NEW^I^45^40^1636^18^^0^BLANK^0^ F65^23-Jan-2007^10:13^AP^ADV PARTS^I^45^40^1919^18^^0^BLANK^0^ F65^23-Jan-2007^10:13^AS^ADV SERV^I^45^40^2057^18^^0^BLANK^0^ F65^23-Jan-2007^10:13^AU^ADV USED^I^45^40^1775^18^^0^BLANK^0^N F65^23-Jan-2007^10:13^BA^B R&M ADM^I^45^40^2823^18^^0^BLANK^0^ F65^23-Jan-2007^10:13^BG^BUILDING MAINTENANCE GM HOLDEN^I^45^40^1311^18^^0^BLANK^0^ F65^23-Jan-2007^10:13^BN^B R&M NEW^I^45^40^2268^18^^0^BLANK^0^ F65^23-Jan-2007^10:13^BP^B R&M PART^I^45^40^2541^18^^0^BLANK^0^ F65^23-Jan-2007^10:13^BS^B R&M SERV^I^45^40^2680^18^^0^BLANK^0^ F65^23-Jan-2007^10:13^BU^B R&M USED^I^45^40^2401^18^^0^BLANK^0^ F65^23-Jan-2007^10:13^F^FLEET^C^50^27^0^17^^0^BLANK^0^ F65^23-Jan-2007^10:13^FC^FORD COMEBACK MECHANIC^I^65^21^140^19^Y^0^BLANK^0^ Cheers, Paul. -- Paul Lambert Database Administrator AutoLedgers