Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
poser
Posting Yak Master
124 Posts |
 Posted - 2008-03-27 : 16:55:59
|
| Hello great sqlteam,I created a dts job that copies from TableA drops/creates in TableB and transfers data.How come when I added a new column to TableA the new column when recreated in TableB (through the dts job) does not have the new column?Thanks for your help!R/P |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-27 : 16:57:55
|
| Perhaps you used the DTS wizard to schedule the job and the job is pointing to the older version of the DTS package. Have you tested your package through the designer?But I wouldn't even use DTS for this. Just use pure T-SQL. DROP TABLE...CREATE TABLE...INSERT INTO/SELECT *.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
poser
Posting Yak Master
124 Posts |
Posted - 2008-03-27 : 17:07:06
|
| The dts job has been running for a while and it is scheduled nightly. Last week we added new columns to the table and I thought since it was doing a drop and recreate, it would create it with the new column. I guess the understanding is that dts is static and does not change when adding new columns.<sigh>Thanks, P |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-27 : 18:49:39
|
| DTS has no way of knowing that you changed your table design. It is code just like an application.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
dts does not recreate structure