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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Re: Alteing table ...effect on DTS Packages

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-06-05 : 10:12:27
Kiran writes "I need to add some columns to my existing existing table in SQ server 2000. I have more than 50 DTS packages which use this table. What is the impact of this change on the DTS packages. Does all the DTS transformations would become invalid or do they still work. What is the best method to go about this situation.

Early response is appreciated."

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-06-06 : 02:00:08
from my experience, if you add a column, no impact

but you should try first on your dev environment, you might have a different case



--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -