Re: Recreate table - including new columns
From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 04/30/04
- Next message: Don Miller: "Re: Local DTS Packages Backup?-Thanks"
- Previous message: Allan Mitchell: "Re: Help!local DTS package scheduling Error!"
- In reply to: Michael Schamberger: "Recreate table - including new columns"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 30 Apr 2004 20:04:17 +0100
You are not missing anything. To do this you will need to add the
attributes yourself and create some new mappings using the object model.
-- -- 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 "Michael Schamberger" <schambergerm@colinsgrp.com> wrote in message news:tn15905mhg7vhdcclg7di194v0pibms40f@4ax.com... > > My source table is on an AS400. I can access it with ODBC and create my table > in SQL. I wanted to schedule a job that would: > > A. Drop destination table > B. Recreate destination table (inluding any new fields/columns in source) > C. Pump in the data > > The problem is that my DTS job ignores any new fields. What am I missing? > >
- Next message: Don Miller: "Re: Local DTS Packages Backup?-Thanks"
- Previous message: Allan Mitchell: "Re: Help!local DTS package scheduling Error!"
- In reply to: Michael Schamberger: "Recreate table - including new columns"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
