Re: Linked Server MS SQL 2000 and Pervasive 7.82

Hi Leonard,

Can you elaborate on what you meant by: "you can use the generic ODBC
driver for connectivity"

I was looking to update tables on MS SQL via DTS, and to do this I'd
need to do joins on tables from MS SQL and Pervasive to check for which
records to add and update.

My ears are open to other ways of doing this, preferably in DTS, but I
would not like to use temp tables.

Thanks,

-d

.

Relevant Pages

  • RE: A couple of R2 Impressions
    ... I agree 110% with Ross M...why why why take away my DTS that I rely and works ... component or I can't use it...it is going to be hard enough to master SQL ... have concern over the decision to dramatically reduce functionality with the ... or good business for MS – it just alienates customers. ...
    (microsoft.public.windows.server.sbs)
  • Re: How do I run a .BAS file saved from a DTS package?
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... I have used DTS for import and export. ... > The DTS Designer is easy to understand and use. ...
    (microsoft.public.sqlserver.dts)
  • Re: Sybase Source. What "data flow source" to use?
    ... but could still use DTS to move data. ... when I right-click over a SQL 2005 database and select Import ... datasources defined in ODBC Datasources on my computer, ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL DTS Job Status
    ... your DB and have the DTS task run an Execute SQL task to write a record to ... Another option is to set up an Operator in SQL Server and have the SQL Agent ... > some of the data that was loaded from DTS. ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Failed when Sheduled
    ... Sql Server and my DTS are and it return this: ... One thing to note is that the "SQL Agent Proxy Account" is not the same as ... Perhaps you could have your DTS Package run WHOAMI.EXE with an Execute ...
    (microsoft.public.sqlserver.dts)