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 |
|
kamranzafar15
Starting Member
2 Posts |
 Posted - 2007-06-29 : 08:11:17
|
| I have a very simple DTS package in SQL Server 2000. There are two connections, one for source database and other for destination database. Both connections uses SQL Server databases. There are many transfomation tasks which simple transfers records from source tables into destination tables.The problem is when I change the destination database name in destination connection and save the package, the individual Tasks in the Package are NOT updated accordingly i.e. it does not change the name of database in the transformation tasks. The Destination definition still point to the name of the old db and when you execute the package the individual tasks are trying to insert the data in the old db.Does anybody know of any “trick” that would update the database specification portion in the Destinations of ALL tasks in a package at once?Regards,Kamran |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-06-29 : 10:17:30
|
| i accidently deleted the duplicate thread instead of locking it._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-29 : 11:48:38
|
OK, I deleted my message which has now become redundant. You can reinstate the referential integrity if you like  |
|
|
|
|
|
|
Changing destination database name in DTS