[Fwd: [PORTS] M$ SQL server DTS package equivalent in Postgres] - Mailing list pgsql-general

Sorry, posted this to the wrong list :(<br /><br /> -------- Original Message -------- <table border="0"
cellpadding="0"cellspacing="0" class="moz-email-headers-table"><tbody><tr><th align="right" nowrap
valign="baseline">Subject:</th><td>[PORTS] M$ SQL server DTS package equivalent in Postgres</td></tr><tr><th
align="right"nowrap valign="baseline">Date: </th><td>Tue, 23 Jan 2007 10:15:06 +0900</td></tr><tr><th align="right"
nowrapvalign="baseline">From: </th><td>Paul Lambert <a class="moz-txt-link-rfc2396E"
href="mailto:paul.lambert@autoledgers.com.au"><paul.lambert@autoledgers.com.au></a></td></tr><tr><thalign="right"
nowrapvalign="baseline">To: </th><td><a class="moz-txt-link-abbreviated"
href="mailto:pgsql-ports@postgresql.org">pgsql-ports@postgresql.org</a></td></tr></tbody></table><br/><br
/><pre>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



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster


</pre><br /><pre class="moz-signature" cols="72">-- 
Paul Lambert
Technical Support Team Leader and Database Administrator
AutoLedgers
Level 3, 823 Wellington Street, West Perth, W.A. 6005
Postal: P.O. Box 106, West Perth, W.A. 6872
Ph: 08 9217 5086 Fax: 08 9217 5055
AutoLedgers Technical Support Desk: 1800 649 987 (Free call) 08 9217 5050 (Perth local and mobile)
Email: <a class="moz-txt-link-abbreviated"
href="mailto:paul.lambert@autoledgers.com.au">paul.lambert@autoledgers.com.au</a><a class="moz-txt-link-rfc2396E"
href="http://www.reynolds.com.au"><http://www.reynolds.com.au></a>
------------------------------------------------------------------------------------
For AutoLedgers technical support, please send an email to <a class="moz-txt-link-abbreviated"
href="mailto:helpdesk@autoledgers.com.au">helpdesk@autoledgers.com.au</a>.

</pre>