Re: DTS and DB2/400

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 03/18/04 

Date: Thu, 18 Mar 2004 16:36:44 -0000

And that is exactly how it is meant to be.

If you want the Key then you will have to rewrite to TSQL and apply
If you want the view then you will need to redo the syntax into TSQL and
apply.

Sorry 

-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"DG" <anonymous@discussions.microsoft.com> wrote in message
news:6BD81826-D3EF-4258-8F35-B16204BE88E5@microsoft.com...
> Hi,
>
> I am in the process of migrating my database from DB2/400 to SQL Server
2000 using DTS and I am encoutering the following problems:
>
> 1. A table with a primary key is being migrated without the primary key
defintition
> 2. A view (called logical file on the AS/400) is being migrated as a table
and not as a view.
>
> Did anyone encounter these problems. Is there any way to get around them.
>
> Thanks

Relevant Pages

  • Re: Why Oracle does not allow rollback of DDL statements?
    ... TSQL did suffer from a lack of modern exception handling. ... So I think we cannot blame transactional DDL for lacking of exception handlers. ... When porting SQL Server apps to another DBMS the problem of lost errors is a major issue in general since TSQL developers have this nasty tendency to only do error checking wherher they think an error could appear. ...
    (comp.databases.oracle.server)
  • Re: DTS object model
    ... Can I do validation & mapping, if I use BulkInsert Command in TSQL? ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... I want to create a text file connection and set the ...
    (microsoft.public.sqlserver.dts)
  • Re: Access Project
    ... Although I have never worked in an Access ADP I believe you need to use TSQL ... You probably want to replace the IIF() constructs with TSQL CASE function. ... Sql Server BOL has a good explanation and lots of examples. ...
    (microsoft.public.access.forms)
  • Re: Importing Multiple text files into one sql table
    ... >the working table you then need to run a series of TSQL ... >ExecuteSQL task. ... >www.allisonmitchell.com - Expert SQL Server Consultancy. ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server - Filter
    ... match their selection criteria. ... > and Sql Server and what worked for me. ... > have millions of records, then yes, you can write regular Access queries ... is to write my tSql statements through com ADO. ...
    (comp.databases.ms-access)