Quick Links

[Fwd: [PORTS] M$ SQL server DTS package equivalent in Postgres]

From:	Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au>
To:	pgsql-general(at)postgresql(dot)org
Subject:	[Fwd: [PORTS] M$ SQL server DTS package equivalent in Postgres]
Date:	2007-01-23 01:45:37
Message-ID:	45B568C1.5060609@autoledgers.com.au
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
Sorry, posted this to the wrong list :(<br>
<br>
-------- Original Message --------
<table class="moz-email-headers-table" border="0" cellpadding="0"
cellspacing="0">
<tbody>
<tr>
<th align="right" nowrap="nowrap" valign="baseline">Subject: </th>
<td>[PORTS] M$ SQL server DTS package equivalent in Postgres</td>
</tr>
<tr>
<th align="right" nowrap="nowrap" valign="baseline">Date: </th>
<td>Tue, 23 Jan 2007 10:15:06 +0900</td>
</tr>
<tr>
<th align="right" nowrap="nowrap" valign="baseline">From: </th>
<td>Paul Lambert <a class="moz-txt-link-rfc2396E" href="mailto:paul(dot)lambert(at)autoledgers(dot)com(dot)au"><paul(dot)lambert(at)autoledgers(dot)com(dot)au></a></td>
</tr>
<tr>
<th align="right" nowrap="nowrap" valign="baseline">To: </th>
<td><a class="moz-txt-link-abbreviated" href="mailto:pgsql-ports(at)postgresql(dot)org">pgsql-ports(at)postgresql(dot)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(dot)lambert(at)autoledgers(dot)com(dot)au">paul(dot)lambert(at)autoledgers(dot)com(dot)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(at)autoledgers(dot)com(dot)au">helpdesk(at)autoledgers(dot)com(dot)au</a>.

</pre>
</body>
</html>

Attachment	Content-Type	Size
unknown_filename	text/html	3.5 KB

Responses

Re: [Fwd: [PORTS] M$ SQL server DTS package equivalent in Postgres] at 2007-01-26 12:19:15 from Tomi N/A

Browse pgsql-general by date

	From	Date	Subject
Next Message	Bruce Momjian	2007-01-23 01:48:18	Re: New US DST Rules & PostgreSQL
Previous Message	Ron Johnson	2007-01-23 01:02:13	Re: Installing Postegres side-by-side with M$ SQL